Reporting: Limiting Number of Records Shown
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
I'm trying to create a simple report showing a list of active users that are assigned more than one non-retired, operational PC's from table (cmdb_ci_computer).
Once I configure the report to group by "assigned to", I get a list of Users with each of their assigned PC's nested beneath, as expected. No problem up until this point.
Now what I want to do is show ONLY those users with results greater than 1.
Again, I do not want to show users assigned only one PC.
So, I have 2 questions:
1. How can I filter the list to only show those users with results greater than 1?
2. Why is this exact functionality only available at the related list level for the same report?
Why not at the base report level?
Any assistance is greatly appreciated.
Thanks in advance.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hope you are doing good.
Did my reply answer your question?
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
