I’m looking for to create a report that provides insights into the aggregated ticket volume over the last time period. Specifically, I want to create a line chart that shows:
- The data aggregated number of created tickets for the past 30 days, rolling backward from that given date in the time period selected.
It would mean I can select as an example Tickets created last 30 days, and then select By week and Last Quarter, and I would get a line chart where the data point is the start of every week over the last Quarter, and the aggregated number of created tickets over the last 30 days from everyone of these dates.
Example:
On 25.11.24 - 530 tickets has been created the last 30 days.
On 02.12.24 - 560 tickets has been created the last 30 days
On 09.12.24 - 600 tickets has been created the last 30 days.
etc etc…
This data should be used to create a chart (I prefer a line diagram for this specific data) to represent accumulated ticket volume over time, so that I can understand if our ticket volume has been increasing or decreasing.
I do not want to see how many tickets was created day by day, or week by week.
