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 comment
Salim Cheurfi
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