Multiple Report Range (Bundles) towards the same Table + Field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2019 06:53 AM
So, currently we havent purchased Performance Analytics and is using the basic Reporting functionality in ServiceNow.
What we would prefer to do is to use reports in order to visualize number of tickets with a duration <15 hours, >15 hours and have found the default content from Report ranges.
When in TEST creating 2 new report ranges (<15 hours + >15 hours) the report is being visualized correctly.
We are using Report Ranges in this sence from following up on internal targets.
Now to my question:
Since Report Range is fixed towards a specific Table/Field I see difficulties IF we would try to follow up different Report range (bundles) in different business forums.
Example: For Service AAA the report ranges should be: <15 hours + >15 hours
For Service BBB the report ranges should be: <10hours + >10hours
Any idea of how to do what I want to achieve.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-22-2019 09:04 AM
You are correct about being restricted to one report range per table/field. The workaround for this is to create different views so which allows for multiple report ranges.
However, I would suggest looking at setting up SLAs and reporting on those. That will also allow you to have as many as needed and to take into account business hours (which is often the next request when you go down this path).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2020 01:10 PM
Hi Adam,
Your answer seems to suggest that what I need to do is possible.
I have a review application that is used by multiple teams. There is one shared score field. The teams need different scoring ranges:
Team A |
green < 90 yellow 80 - 90 red >80 |
Team B |
green < 90 yellow 75 - 90 red > 75 |
When you say
The workaround for this is to create different views so which allows for multiple report ranges. The workaround for this is to create different views so which allows for multiple report ranges.
are you referring to database views or form view? Would you have an example to share?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2020 01:52 PM
It needs a database view so it isn't a pretty option, but it should work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-18-2020 06:29 AM
Thanks!
I used a database view and once I added a second table (which actually isn't a bad idea for this custom app) and now I've got a second set of ranges.