Vor Kurzem aufgerufene Suchen
Keine vor kurzem aufgerufene Suchen
End Users with Multiple Open Tickets
Beantwortet
Zendesk Luminary
Gepostet 09. Juni 2021
I am looking to build a report that places end users into bracket percentages. Ideally, this would group end users into categories like so if they have more than one ticket open:
% with 1 ticket open
% with 2 tickets open
% with 3 tickets open
% with 4 or more tickets open
ETC
Has anyone tried to create this or have any advice for an approach? Explore is pretty limiting on the end user data side.
0
3
3 Kommentare
ZZ Graeme Carmichael
Danielle
That is a fun question. It looks like we can use the new aggregate functions here.
Use the metric DCOUNT(Requesters) and filter by ticket status so that we are only looking at active tickets (OPEN, NEW,PENDING)
Now create a custom attribute for our row to split the requester into buckets depending on the tickets they have. Best to use a Switch function.
So you have something like this:
To display as percentages, go to Results Manipulation>Result Path Calculation:
1
Danielle
@... Thank you so much for the response! This was very helpful. I have a particularly large data set, so it took some filtering to render results, but I was able to recreate!
Cheers!
0
Raphaël Péguet - Officers.fr
ZZ Graeme Carmichael Thank you !! Nice tip, but don't you should add: Case 0: "0 Tickets"? Otherwise 0 would be in default which is very wrong
0