Explore: Ticket Created Count week over week (% increase/decrease)
Hi Everyone!
I am trying to create a report that shows the ticket created count by week as well as the percentage increased/decreased from the previous week. I found the Explore Recipe: Compare last month's tickets to the 12 month average but it isn't quite what I'm looking for. While I can alter it to be weekly average, it isn't showing me a rolling count/percentage week over week. I've attached a mock up of what I'm looking for. Any help would be appreciated. 
-
- Select the Table visualization type.
- Add a date filter.
- Add a date field to the Rows section ("Ticket Created - Week" or "Ticket Created - Year and Week").
- Add the metrics "D_COUNT(Tickets)" and "COUNT(Tickets)".
- On the right menu bar, go to Result manipulation, then Result path calculation. Under "COUNT(Tickets)", in the Pattern box, select "% of difference", then in the Path box, select "On rows", and in the Reference box, select "Previous element".
- Click Apply.
Vous devez vous connecter pour laisser un commentaire.
1 Commentaires