I'm trying to building a daily report that shows # of open ticket by agent (showing last 30 days only - rolling), and in different aged buckets. It has to be cumulative. For example, Agent A had 45 open ticket on Day 1, and on day 2 he had 53, and now day 3 he had 35 and so on
Here's is what I have done so far:
Setup custom metrics for aged bucket. One example of the code is below:
And then selected the 5 aged buckets in WHAT section (see below)
And then I chose the following in HOW section (not sure if Day of Year Ticket update is correct?):
And then did the filter for the rolling 30 days period below:
After all this, im getting the following result:
is this the right way to get this guys? I'm not sure if I'm picking # of open ticket correctly. Can someone please check and guide me?
Please sign in to leave a comment.