Using the Trend and Relative Operators

ttpo9
Tera Contributor

Our 24/7 Servicedesk is divided into 3 8 hour shifts.

8AM - 4PM

4PM- Midnight

Midnight - 8AM

I want to create a report to see how many tickets are created in each of those different shifts for the last week/month.  

After going through some articles, it looks like I can do it by using the Trend and Relative operators in the reporting tool. Anyone have any ideas on how create this report.

Thanks

3 REPLIES 3

Arnoud Kooi
ServiceNow Employee
ServiceNow Employee

This seems a case for Performance Analytics! Do you have it available?


Ashby
ServiceNow Employee
ServiceNow Employee

TP,


Per Arnoud's suggestion; if you have access to Performance Analytics you can accomplish this by setting up a bucket group for the three 8 hour shifts.     There is an OOTB example using hour of day under Performance Analytics > Bucket Groups you can use for reference.     You will need to create a similar bucket modifying the start and end times to match your 3 shifts.



To accomplish this you will need to do the following:


1. Create a Bucket group for the 3 shifts


2. Create a Breakdown Source for the shifts and associate it to the bucket group


3. Create an Automated Breakdown for the shifts and associated it to the Breakdown Source.


        a. On the breakdown mappings tab, you will need to associate the table and field you want use as the qualifier.   In my example, I used opened_at for incident.


        b. On the indicator tab, you will need to associate the indicator (Number of Open Incidents) you want to apply this breakdown to.


4. Create or Re-run a job including the indicator with the new breakdown.  


find_real_file.png



find_real_file.png


find_real_file.png


find_real_file.png


ttpo9
Tera Contributor

Thank you John,



PA is not quite yet set up in our environment, so I was looking for alternatives reports to get the data for the shifts.