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!

[AndersBGS]

Hi @mania ,

As other already suggested / said, calculation is not possible through the report designer. You instead need to utilize PA for this. 

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

Best regards

Anders