Skip to main content
Visit Freshworks.com Visit Freshworks

Hi Freshdesk Community,

I’m looking for some help creating 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.

 

Does anyone know how I can achieve this?

Any tips or guidance on how to set up this type of visual in Freshdesk’s analytics or reports would be greatly appreciated!

Thanks in advance for your help!

Hi ​@andersreve 

I hope you are doing well :)

I understand that you want to create a curated report and group by weeks onto a line chat. You can create a line chart based on week. i have added the article on creating. custom report along with an illustration below,

https://support.freshdesk.com/en/support/solutions/articles/50000001028-custom-reporting-basics

Feel free to respond to this thread for any queries :)

Thank you

Thanks, I am aware that I can create custom reports and widgets.

I am however specifically looking to display accumulated/aggregated number of tickets at certain 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.

I’m not sure if I am able to express what I need clearly? 😅

Reply


Terms of Use