Need some help to create a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2025 02:39 AM
There is a custom table named ABC, in which records will get stored whenever some one subscribes to it, and records will store like below..
Topic Name, Subscribed(it's say "1"), Date, and User
Now, I report I want to show like..
Topics | Subscription Count |
Topic 1 | 10 |
Topic 2 | 20 |
Topic 3 | 30 |
Can some one please help on this? @Ankur Bawiskar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2025 02:45 AM
Each row of that table is for particular user right
You want total count of that Topic summing up for all the users.
You can use Bar type report
Something like this I did for incident to show how many are there in each state
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2025 07:47 AM
@Ankur Bawiskar is it possible to provide in list view instead of bar graph?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2025 08:10 AM
If you want list view, please search for "list" in the Type
Then save and run the report again to see the results.
Please mark correct or helpful if it helped 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2025 08:23 AM
It will not work.. LIST will show only fields which are available on table.. but here we are counting subscriptions.. @Sruthi17