Multiple Report Range (Bundles) towards the same Table + Field?

jonas_cederlund
Kilo Contributor

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.

4 REPLIES 4

Adam Stout
ServiceNow Employee
ServiceNow Employee

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).

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!

Adam Stout
ServiceNow Employee
ServiceNow Employee

It needs a database view so it isn't a pretty option, but it should work.

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.