I need to produce 2 trending reports for qty of tickets that exceed an SLA daily. I need these to show daily over time for a rolling 3 months. I don't think I am going to be able to do this, but am looking for thoughts or ideas.
The 2 SLA's breach conditions I need to trend are:
- 1st response > 1 business hour
- Tickets older than 7 days (this is for a subset of tickets and would not include those that are scheduled).
Any help would be appreciated
Thanks,
Andy