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?
Hey @Adam Stout
I m using Heatmap visualization and in that created a metric on Case Table where the metric is like Created and Updated vs HR Service.
But When I get the count in Heatmap its correct on Visual, but as soon as Drilling down i m getting the wrong count i.e. list of cases
attaching the snapshot of it.
Suppose i click on the "99" then its giving me the o/p in list as
Please help me with this, How should i solve this ?
Its real-time scenario.
