Report to show top and least used Catalog Items to submit requests

[Dee S]

I've a requirement to create 2 separate reports that shows top 10 and least 10 used catalog item to submit requests.

I should look something like below:

The report should contain 2 columns like above Catalog Item Name and Count of Requests submitted.

The reports on above images are not actually normal list reports available. I couldn't figure out which kind of report it is. If someone knows the type please let me know

Need help in configuring the requirement.

[Hitoshi Ozawa]

Won't be a list but can create a bar chart using report.

Source type: Table

Table: sc_req_item

Type: bar

Group by: Item

Stack by: None

Aggregation: Count

Max number of group:10

Show Other: uncheck

[SAI VENKATESH]

Hi @Dee S 

based upon the image I am assuming they have used performance analytics such as formula indicators or else they are using metrics to get the data 

and the other way may be storing the count of items submitted in a custom field.

These are the possible scenarios that we can do in ServiceNow 

Thanks and Regards

sai venkatesh 

[OlaN]

Hi,

Creating a report that shows the top most used catalog items should be so hard, you'll need to summarize the items ordered from the table [sc_req_item] and group by "Item", then apply filtering according to your needs.

The least used is a bit more tricky, because of two things.

Reports summarization automatically show the grouping by displaying the most frequently used first, there is no option to show the least used first, so the standard reports might be a insufficient for this task.
They also only show data that exists, and if you would report in same approach, from sc_req_item, you only get the items that's been actually used, and therre might be additional catalog items which have never been used (will not show up in the report).

It requires a different approach to get those records.