I have a simple report for Tickets created by Month.
Columns are Ticket Created Year and Ticket Created Month.
I want to add a linear trend line so the growth is easy to see, but the last month's data (being partial) significantly alters the trend line. At the beginning of each month it's mostly useless.
The forecast feature is not really what I want here and I can hide the current month's data point, but it's I'd really like to keep it visible.
Is there a way to limit the trendline to be calculated on a subset of the data in the chart?
Please sign in to leave a comment.