how to calculate Average Days Open (1 Day, 2 Days, +3 Days) and Percentage in report

[mania]

Hi,

I have created a report to the below information.
Name of Report: Customer Report
Type of Report: Bar Graph
Data Elements Required: Customer Name
Total Number of Cases
Case Type and Percentage
Case Sub Type and Percentage
Average Days Open (1 Day, 2 Days, +3 Days) and Percentage

But how to calculate Average Days Open (1 Day, 2 Days, +3 Days) and Percentage in the same report.

Can anyone please help on this, It will be useful.

Thanks!

[Dr Atul G- LNG]

Hi @mania 

PA is best way to do this.

[mania]

@Dr Atul G- LNG , @Mark Manders , @AndersBGS 

Thanks for responding!

Can anyone please tell me what is the exact plugin for PA? and also is that paid or free plugin?

Thanks!

[Dr Atul G- LNG]

Hi @mania 

Its paid but you can check with you ServiceNow Account manager for same.

https://www.servicenow.com/community/platform-analytics-articles/performance-analytics-standard-plug...

https://docs.servicenow.com/bundle/xanadu-now-intelligence/page/use/performance-analytics/concept/c_...

[Mark Manders]

This can't be done in one report. Just put the data on a dashboard to show everything instead of putting it in one report that needs explanation to read.

To get the data calculation you will need to use PA.