Report range is used to define data intervals that are used in bar and pie charts.
Reports only show historical data. It is not possible to set report ranges for dates in the future.
There is a “sys_report_range” table in which all report ranges are stored. We can create customize report range in following ways
navigate to Reports > Administration > Report Ranges.
Element- on which field of table you want to use it
Upper duration value- In which duration you have to calculate range. Ex. In the above field it will be less than 1 week hence the upper duration value is 7.
Name- In which table you have to apply. It is table limitation. This report range is not used for any table rather than incident.
Upper Int Value-Example: One report range has an upper limit of 10 and an Order of 20. A second report range has an upper limit of 5 and the Order of 19. Values from 5 to 10 display the formatting specified by this range.
In the report of the incident table, you can use this customised report range.
For more detail analysis, Please check below ServiceNow docs for reference.
Not sure I follow the "this table" part, but yes.
I've created 4 Report Range records on [sys_report_range] for the time ranges I need (7, 30, 60, 90, days) under the Global application.
The ranges are explicit for grouping based on the <sys_created_on> of the [task] table, as these are needed for Cases and Incidents.
Issue is, there aren't any options in the reports chart configuration that allows you set what range to use.
It just, uses the OOB ranges.
So.....the 'sys_created_on' field doesn't exist on the [sn_customerservice_case] table, it's an extended field from [task].
(our [sn_customerservice_case_core] table is extended from the Case table)
FWIW, I did try to build it this way first, but the Case table isn't an available table in the 'Name' field in the Range record.
So, since I can't create the ranges on the table I'm reporting against, and building them on the root extensor table doesn't work...I guess my question is now: "How do I build a Report Range that's functional on the Case table, that uses a field (Element) that's extended from the Task table?"
