I'm new to Insights and would like to see if anyone has some tips and tricks for reporting on my user case.
What I want to create, is a report that shows an overview of solved tickets the last 30 days, but also what category the tickets have and what store it relates to.
So basically a list of all stores, how many tickets that are relating to each store, and how many tickets in each category. Ex. Store 12345 has 12 tickets, 2 regarding staff, 5 regarding payment and 5 regarding parking.
This is of course for internal follow-up, to see if some stores get more complaints than others, and in a particular category.
Currently, the categories are entered as tags using macros and store numbers are entered in a custom ticket field.
Is there anyone who has experience of this kind of report or has any ideas on how to set it up?
Thankful for any help,