Date Ranges for Pivot Tables, Heatmaps, etc?

Daniel Needles1
Kilo Guru

Recently I was working on identifying stale devices that still showed operational.  I was happy to find that when Bar Graphs would chunk time for Most Recently Discovered into Same Day, 2 days, 2-5 days, 5-7 days, 1-2 weeks, 2-4 weeks, 1-2 months, > 2 months.   However, when plotted against device count and subdividing the bars by class  (for cmdb_ci_hardware) the information became less intuitive.  So I tried switching to a pivot table or heat map.  There it reverted to using the specific datetime for each element which made the data meaningless.  

Is there a way to use the "date chunking" in these other report types (pivot table, heatmap, etc.)?

Is there a way to modify the groupings used by Reports if for example I want the categories to be week by week?

find_real_file.png

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

Take a look at Report Ranges.  They are useful but I would highly recommend looking at Performance Analytics for week over week trends.

View solution in original post

6 REPLIES 6

Adam Stout
ServiceNow Employee
ServiceNow Employee

I would submit a case to have Support have a look at that.

Thank you!