How to find the top 20 most order items in reports

Chandu Telu · ‎07-01-2017

HI Team,

I Need to create a report on that reports i need to show top 20 most order items in reports

Can some one help me on this

Thanks

Chandu Telu

gauravchoudhury · ‎07-02-2017

Hi Chandu,

I created some dummy records to help you show a dummy report with you required request. As you can see it has shown me a list of all available items in a bar chart.

Please refer to the screenshot below:

If you are looking to have only top 20 then in that case, simple export the require report to excel and then use a pivot table to sort & filter your required data. After which you can use Bar chart or any form of chart in Excel itself.

The process could be a tad bit longer but certainly assures the end result without scripts.

View solution in original post

gauravchoudhury · ‎07-01-2017

Hi Chandru,

The simplest way to get this done would be to export a raw report from ServiceNow to Excel and then create a Pivot to filter the required fields. Once done, run Sort/Filter option in Excel to show all required values in ascending or descending order.

You would need to create a report on the Requested Items table [sc_req_item]. You should have those fields like Number, Item & other fields as per your need.

In your excel report, you can filter via items and sort them as per their counts they have been ordered.

If you are well versed in using a Pivot Table on an excel sheet, it should be pretty simple.

Please Note: Kindly LIKE or MARK Correct/Helpful, if you are satisfied with my response.

Chandu Telu · ‎07-02-2017

Hi Gaurav,

Thanks for your response

Can please provide the more information

Thanks

Chandu telu

gauravchoudhury · ‎07-02-2017

Hi Chandu,

Please elaborate what additional information you require.

Chandu Telu · ‎07-02-2017

I have to create a bar chart and it's should show the most order 20 items we can write a script include and call the script include from filter using javascript

But I want to do with without scripting can we have any option to achieve this

THANKS

Chandu Telu