Hello, I’ve been asked to compare last years ticket count to this year. What is the best way to pull this information? They would like it broken down by Month and weekly view to show the busiest times of the year. Thank you in advance for your assistance.
Unfortunately, I have only been able to find a clunky way of doing this.
First, you can see the total tickets by month in analytics. Report / Ticket - select your date range. Then scroll, and you will see “Total tickets over time.” You can hover over each section, and it will give you the total number of tickets submitted:
For weekly, you can adjust the time frame by month, and it will give you the total tickets as well. However, it does not have “Week 1” like your spreadsheet shows:
As I said, this is clunky and time-consuming, but it will probably be the best way to gather that information. You can save each module as an image or as a pdf as well. I hope this helps
Another way is to create a custom view and the export that date. This way you can filter and create graphs within excel A little extra work for you but you can also submit this idea in our idea exchange to have it part of our analytics.
Here is the filter that I configured:
- Ticket State > Closed and Open
- Created Date
Added a column for the export “Submitted on”
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.