How can I only show groups that have more than one value in a report?

taylor11
Giga Contributor

Hello! I am trying to pull a report for "repeat offenders" in the last 48 hours for the Service Desk. I was hoping to just run a report on the incident table and group by customer but only want to see grouped values that have more than one record. For example in the screen shot below, the highlighted rows are the data I would like to see. I would like to filter out any other grouped row that only has one value but I am not sure how to do so. Any help is appreciated!

find_real_file.png

3 REPLIES 3

Brad Tilton
ServiceNow Employee
ServiceNow Employee

This would be a lot easier to do with a Bar chart where you group on the customer and could get the top 10 or 20.


Hi Brad, thank you for your suggestion! I tried using a bar graph but the users requesting the report would prefer a list if possible. It's not a "must have" report so I may be able to persuade them to either sift through and ignore the single record rows or to go with the bar graph. Still would love to see this as a future can-do in the system.


gyedwab
Mega Guru

Hi Taylor,



Would a pivot work for them? (I know that sometimes the reason people prefer lists/pivots is so they can search for text).



If so, you could use Explore Analytics to create a pivot -- in the screenshot below, it's grouped by 'caller', and the output filter above the pivot excludes any 'caller' where the count of incidents is 1. It's real-time, and the user can still drill through to details to get the list of incidents, and open the form.


Screenshot 2017-11-02 10.03.13.png