Hoping for help on this one:
I am doing statistics on support tickets and whats to track how many tickets are open on a given date from when a ticket is opened until it is solved.
A somewhat smaller version of the ticket-table is like this:
- TicketID
- CreatedDate
- ResponseDate
- ResolutionDate
I’ve come so far as to understand that I have to generate a separate table, where I autogenerate dates between CreatedDate and ResolutionDate and add counter to keep track on how many active tickets there are on a given date, but I am having severe trouble getting it together.
The resulting table I think looks like this:
or
- both with the purpose of counting number of active tickets, active being defined on a given date if not resolved.
Any good advice on this?
