How do you track the number of open tickets at a particular date?

[steevels]

I'm trying to do a report based on created, resolved and open. Fairly standard if I want that done for right now, but what if I want to look back to a date three months ago and tell how many open tickets there were on that day?

I'm sure it's really straight forward, but I've been going around in circles for hours now and I can't get it.

[Karthik Reddy T]

Hellow Steve,

If you want generate the report based for incident which are created 3 months before refer the below screenshot.

If you want generate a report for incident which are opened on particular date refer the below screenshot.

Let me know if you need any other information regarding this.

[steevels]

Hi Karthik,

It's not when a ticket was opened, that is fine but determine the number of tickets that had any other status that resolved or closed at a particular date.

[Karthik Reddy T]

Hello Steve,

You can use group by in the report .  

Please explain elaborate.

[steevels]

I'm trying to determine the growth of our ticket queue. So I need to be able to see how many tickets were still active at the end of a particular week. I have no trouble with determining the number that were opened or the number that were resolved but I'm struggling to determine the number of tickets that were still being worked on at that moment in time. If the group by option will allow me to do this please let me know how as I've looked through the list and there doesn't seem to be one that will help.