Reporting on Request stages
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2018 10:24 AM
Hi,
I need to show a bar diagram with all the RITM and the stages each RITM took. Can anybody guide how I can do this
Regards,
Anusha
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2018 10:35 AM
You'll want a metric on stage on RITM and then a report should be pretty easy from there.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2018 11:31 AM
Hi Adam , I have the metric. But how can I build the graph with x axis having all RITM numbers and Y axis Having/showing all the stages. I am new to reporting.
Regards,
Anusha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2018 10:52 AM
Take a look in the Metric Definitions view at the "Incident State Duration" - first step is to make a copy of that for Requested Items and point to the field that you want to monitor.
Once that's configured, each time a Request changes State (or Stage, or whatever field you set it on) then it'll create an entry in the Metric Instance table. You should be able to build your report against that table, filtering for Definition = ReqItem State Duration (or whatever you end up calling the new metric definition) and you'll get the rows you want to report on. Then it's just a matter of tweaking the visualizations to see what you want to see.
Note that you're going to be getting a new row for each State that a ReqItem goes through, so depending on what you're reporting, you may end up needing to use the Count Distinct option in your report to count each ReqItem only once. Only for those things that require it though.
For example, if you want to report on all of the ReqItems that were in the Waiting state, then you may want to use Count Distinct depending on whether or not you want to include ALL the times a ReqItem was in Waiting, if it was in Waiting more than one time.
Hope that made sense!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2018 11:49 AM
Hi Josh,
I have the metric. But how can I build the graph with x axis having all RITM numbers and Y axis Having/showing all the stages. I am new to reporting.