Need some help to create a report

Sathwik1
Tera Expert

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..

 

TopicsSubscription Count
Topic 110
Topic 220
Topic 330

 

Can some one please help on this? @Ankur Bawiskar 

15 REPLIES 15

Ankur Bawiskar
Tera Patron
Tera Patron

@Sathwik1 

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

AnkurBawiskar_0-1753263945982.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar is it possible to provide in list view instead of bar graph?

If you want list view, please search for "list" in the Type

Sruthi17_0-1753283391052.png

Then save and run the report again to see the results.

 

Please mark correct or helpful if it helped 🙂

 

It will not work.. LIST will show only fields which are available on table.. but here we are counting subscriptions.. @Sruthi17