Unsolved tickets displayed per week and age bracket? | The place for Zendesk users to come together and share
Skip to main content
L
Love12
August 9, 2021
Question

Unsolved tickets displayed per week and age bracket?

  • August 9, 2021
  • 1 reply
  • 31 views

Hello all,

I am trying to build a simple report with a chart that shows the number of unsolved tickets in each age bracket over time. E.g. week-by-week over a rolling 3-month period.

My starting point is the table below but I'm completely at loss as to display it in a graph (or table) per week.

Has anyone manage to solve such an approach?

Many thanks in advance!

/Love

      1 reply

      Dave12
      Dave12Employee
      Employee
      August 10, 2021

      Hi there!

      It looks like you're using this recipe, but using "Unsolved tickets age brackets" instead: Explore recipe: Displaying tickets answered within different time brackets

      So you've got Tickets as your metric, and "Unsolved tickets age brackets" under Rows. The next thing to do is to add dates as Columns -- so under Columns, you could add "Ticket created - week of year", and then add a filter on that same attribute to limit your report to the past three weeks. Then you can select a line or bar chart using the Visualization type button on the right side of the query builder interface. (Note that for that short of a period of time, no ticket will fall under the "> 30 days" column since your total timespan is less than 30 days, so you might want to extend your timeframe a little longer).

      You might also find that the Solved like dwarfs the others – in that case, try adding another filter on "Unsolved tickets age brackets" and exclude "Solved" (or only select the brackets you want to see).

      Hope that helps!

        Terms & ConditionsAccessibility statement