Report/Pivot Table - Requesting Help showing simple pivot of incident state totals

ChadBaus
Tera Contributor

Coming from a previous ticketing system where the incident state totals were automatically calculated, I would like help with this feature to build a report to add to a Dashboard.

 

We have Client Totals based on incident state calculated as

ChadBaus_0-1671058801614.png

 

I looked at Pivot Tables but they have the extra column that's not needed for (empty) in this case, and I would like the incident states to be in rows and their current totals to be counted.

 

Is this possible within ServiceNow?

1 ACCEPTED SOLUTION

I don't think that is possible.

There are some alternatives:

1. By creating a list widget you get a list of all widgets grouping by 'Incident State' and filteringAdityaRaute_0-1671204388925.png

2. Creating a pivot table widget and having 'incident state' as the Row and applying the same filter.

AdityaRaute_1-1671204557491.png

View solution in original post

5 REPLIES 5

I don't think that is possible.

There are some alternatives:

1. By creating a list widget you get a list of all widgets grouping by 'Incident State' and filteringAdityaRaute_0-1671204388925.png

2. Creating a pivot table widget and having 'incident state' as the Row and applying the same filter.

AdityaRaute_1-1671204557491.png