We are looking to implement a Weekly On-Call process for after hours support. I am using the Tickets Created by hour report to understand the volume of Tickets Created during our non-Business hours.
Currently I am using a filter to look back at the last 90-days. This outputs the sum of the tickets Created over the last 90 days, but I would prefer to get a Weekly average.
I can add Week (Mon-Sun) (Ticket Created) as an attribute and then average the rows, but this creates a very busy report and does not allow me to use the graph
I would like to use a Custom Metric to output the Average Number of Tickets created per Week.
One thought was to divide the #Tickets Created by 13 (~13 weeks in the 90 days. However this means that I cannot adjust my report filter. Is there a better way to code this so it is dynamic?
Please sign in to leave a comment.