how to create reports with percentage in servicenow

[Vani14]

how to create reports with percentage in ServiceNow.

[Rajesh_Singh]

@Vani14 

to create a report with percentages using a pie chart as an example:

1. Navigate to Reports: On the left-hand navigation pane in ServiceNow, type "Reports" in the filter navigator and click on "View / Run" under Reports.

2. Create a new report: Click on "New" in the top-right corner to create a new report. A new window with report options will appear.

3. Choose report type: In the "Choose a data source" section, select the desired table (e.g., "Incident"). Next, in the "Choose a visualization type" section, select "Pie" as the report type.

4. Configure the report: In the "Configure" tab, set the following fields:

   a. Title: Enter a title for your report (e.g., "Incident Priority Distribution").

   b. Group by: Select the field you want to use as the basis for calculating the percentages (e.g., "Priority").

   c. Aggregate: Choose the function you want to use for aggregating the data. In this case, select "Count".

5. Add the percentage calculation: To display percentages in the pie chart, click on the "Style" tab. In the "Pie Chart Options" section, check the box next to "Show Percentages" to enable the display of percentages for each segment of the pie chart.

6. Save and run the report: Click on "Save" in the top-right corner of the Report Designer window, then click on "Run" to view the report.

Now, the pie chart will show the distribution of incident priorities with their respective percentages. You can use a similar approach to create reports with percentages using other visualization types (e.g., bar, column, etc.) by configuring the appropriate fields

[LetItRain]

I am not seeing "Show Percentages" in "Pie Chart Options". Am I missing something?

[alexandrutu]

Hello Rajesh,

I might have an uncommon query as the above steps are not working. I am working on Data Quality / Compliance reports, and I want to build a report that will show me how many application services are respecting the naming convention. It can be a percentage, but an issue might be that we are currently at 0%. I can't get my way around this, I have selected pie as chart type, but could not work as my denominator lies in the condition?

Thank you!

[AndersBGS]

Hi @Vani14 ,

The answer is very much based on you requirement. If you just want to show the distribution on e.g. incident priority in percentage, then yes - this is possible. If you would like to do a little more advanced calculations based on several tables, then no - report designer does not have this functionality. You instead need to utilize performance analytics.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders