End users with multiple tickets in buckets
I am looking to build a report that places all the active end-users who have created tickets into buckets of:
__% of them have 1-10 tickets
__% of them have 11-20 tickets
__% of them have 21-30, etc.
I was looking at this post and tried to modify it to show the above data, but the numbers I'm getting back do not seem accurate as I ended up with 49% have Over 101 tickets.
Below is the attribute calculation I created
SWITCH ATTRIBUTE_ADD(COUNT(Tickets),[Requester ID]){
Case 1:"01 - 10 Tickets"
Case 2:"11 - 20 Tickets"
Case 3:"21 - 30 Tickets"
Case 4:"31 - 40 Tickets"
Case 5:"41 - 50 Tickets"
Case 6:"51 - 60 Tickets"
Case 7:"61 - 70 Tickets"
Case 8:"71 - 80 Tickets"
Case 9:"81 - 90 Tickets"
Case 10:"91 - 100 Tickets"
DEFAULT: "Over 101 Tickets"
}
-
Hi Greg -
The CASE statements of the SWITCH function look for exact values -- so when you have "Case 3: (etc.)", that's only going to match if the ticket count is 3 exactly. I think you'll have better luck using an IF/THEN/ELSE structure (e.g. paraphrased: if the ticket count is >=1 and the ticket count is <=10, then "01 -10 Tickets", etc.) instead of SWITCH. See Using the IF THEN ELSE function for more information.
Please sign in to leave a comment.
1 Comments