"Count of Assets by Model" - Basic Reporting

Daniel Wilborn
Tera Contributor

Looking for a way to generate a report that appears like a pivot table, but does not require a column value... I just want a count of the records in a certain bucket.  Bars, Pies, not acceptable due to truncation and poor appearance... 

Like below but just the Model name and Total...

DanielWilborn_0-1715812248326.png

Closest thing I've come up with is a grouped by model list ... which exports as a standard list and doesn't meet the need.  Why does this not seem possible in basic reporting?

 

1 REPLY 1

Maik Skoddow
Tera Patron
Tera Patron

OOTB such a report is not available. Maybe you could create a grouped list report and add a function field for displaying the number of assets per grouped model. And for that function field you will have to build your own function. However I never did this before. See https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/build/platform-function...