Recent searches


No recent searches

How to report on most increased value since previous week



Posted Apr 24, 2024

Hello, 

 

I tried to search for this but I'm not sure if it's actually something tricky to achieve or if it's just hiding in front of my eyes. 

I need to create a report to show trending issues week by week.

We have a multiselect field that is our custom tagging system. I need to create a report that weekly will show which values had the highest increase since the previous week, to spot potential trending issues.

 

i.e. if we got 3 tickets in week 15 for battery not charging and 10 tickets in week 16, I'd like to have a graph that shows it to me.

Basically, a sparkline graph but sortable for the highest increase (trend), and that shows me the increasing amount (i.e. +7 in the previous example).

Can you give me some advice on how to achieve this?

 

Thanks a lot everyone for your help!


0

1

1 comment

image avatar

Salim Cheurfi

Zendesk Customer Care

Hi Roberto, 
 
You're trying to see the variation of ticket with a specific fields and see the trend/variation for each week to see the difference from the previous week (+ or -). 
 
A great way to do this is to create the report with the Update History Dataset, choose the Waterfall graph format ten use the metric D_COUNT(Tickets) with the attribute Ticket Created- Week of the year. 
 
You will have to filter by Change-Field "battery not charging" and Ticket created year (so you can get results only for the weeks of a specific year).
In the Result Manipulation feature select the pattern difference from column on previous element . 
 

 
I hope this helps 

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post