Percentage in Multilevel Pivot Report

[anubhavr]

In Multilevel Pivot Report, we have Aggregation field with values like Count, Sum, Average.

Do we have any feasibility to show Percentage in place of Sum. Like how much percentage it has out of Total value??

[gyedwab]

Hello Anubhav,

Unfortunately, ServiceNow's pivot report is fairly limited, it won't let you do things like "% of total" or "running total", or to write formulas like you're used to in Excel.

You can do this against ServiceNow data live using Explore Analytics:

Detailed Pivot Analysis of Incidents

The % of total is as easy to define as this:

If you were logged in to ServiceNow, you could have it live, on the ServiceNow dashboard, and drill through to the data. All of the definitions are drag-and-drop, in real time, and you can also do formulas/ calculations.

[anubhavr]

Hi,

This seems to be useful. Can you tell me how to implement this in ServiceNow Reports? Or how to create reports for %?

[gyedwab]

Hi Anubhav,

Once you've logged into Explore Analytics, you can follow the steps here to connect it to ServiceNow:

https://www.exploreanalytics.com/wiki/index.php?title=Configuring_a_ServiceNow_Data_Source#Setting_U...

Once you've connected Explore Analytics and ServiceNow, here are the steps:

1) Go to File > Create a new report

2) Select your ServiceNow data source, and the desired table (e.g. Incident), then click Next.

3) Give the report a name and select Pivot report.

4) On the left hand side, you should have the list of available fields. Drag the groupings you want into the rows and columns.

5) On the left hand side, where it says 'Value Fields', select Count, and click the pencil icon.

6) In the dialog that appears, click the Display As button, and then use the Display As dropdown to select % of Total.

You should now have the % of total for each of the groupings. You can click "Filter Data" at the top to filter the data set down, or drag additional fields into the Value fields area to get sums/averages/counts.

[anubhavr]

Hi,

Is this feature free or need to Pay for this. This may create Violation I guess to connect Customer Instance with outsider.