Hi! I am trying to create a KPI for our tickets to show progress/decline in graphical view or something similair. More spesifically, I need to know the status of all our tickets at a speciffic time. E.g. how many tickets were open january last year, how many new ones were created and how many where closed. Preferably sorted by classefications. I have found it challenging to create this in zoho using reports and I have previously used a script i created to solve this, but this takes a while to run and im not sure it can handle much larger datasets.

If anyone knows something that could help it would be much appreciated!

Best regards
Nicolai