Top 5 Fields per Month
Hello!
I used to use this attribute in insights, with some customizations to make it a ticket field instead of a tag, and can't figure out how to make it translate to Explore:
- SELECT # Tickets WHERE TOP(5) IN (SELECT # Tickets BY Ticket Tag) WITHIN (Month/Year (Ticket Created) ALL OTHER)
I can see how to get the top 5 in Explore, but it seems to be the same fields each month instead of actually changing based on why customers were contacting us. One field will show 5 tickets were created, when I know there's another field not shown with more tickets.
Amy's answer in this thread is exactly what I'm looking for, but in Explore. Any help appreciated!
-
Hi Christina -
Thanks for writing in. Would you be able to share details or a screen shot of how your currently pulling the data in Explore? We might be able to just tweak your settings slightly. Looking forward to hearing back.Brandon Tidd
729 Solutions -
Hi Brandon Tidd-
Metrics is just COUNT(Tickets), Columns is Ticket Created - Week of Year, and I'm using this for Rows:
The result is that it gives me the Top 5 Store Categories of all time, instead of the top 5 for that particular week. Here's the overall look:
I know for instance in the third week here, there was an issue that would have been a top 5 category, but it doesn't show up here.
-
Hi Christina -
Thanks for the additional information! Have you tried adding a date filter to your query? That might solve your problem. Hope this helps!
Brandon Tidd
729 Solutions
Iniciar sesión para dejar un comentario.
3 Comentarios