We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

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

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

Thank you!