Solved

Tech Ticket Comparison (Last year vs Current FY)

  • 9 October 2023
  • 3 replies
  • 49 views

Badge +1

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. 

icon

Best answer by Kathryn Carter 11 October 2023, 15:34

View original

3 replies

Badge +1

 

Userlevel 7
Badge +13

@ahuff Thank you for submitting your question to our community! 😄

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 😄

Userlevel 7
Badge +16

@ahuff 

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