We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Asset management report request

Tom Hansen
Kilo Contributor

I've tried unsuccessfully to create a pie chart displaying the number of assets at a location that meet our refresh criteria versus those that don't.  An example:
Filtering for:
Location is San Francisco

Model Category is DisplayHardware

State is in Use

 

I group by Refresh date.

 

I know this is incomplete.  If I add a filter for refresh date is at or before today, I omit the number of items that do not meet that criteria.  Is it possible to have a piechart that shows both figures, number that meet the refresh criteria and those that don't?

0 REPLIES 0