Using the Trend and Relative Operators
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2017 09:55 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2017 03:17 PM
This seems a case for Performance Analytics! Do you have it available?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2017 12:59 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2017 06:38 AM
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.