Is it possible to to use a report for a calculation?

[Peter W1]

Hello,

I am trying to create a new report that shows system uptime as a percentage for the last 30 days based on a custom duration field in the incident table. Example: There are 3 incidents in the last 30 days with a sum total duration of 2 hours and 14 minutes. That represents a total of 8040 seconds. So the uptime percentage that would be displayed is 99.69 since there are 2,592,000 seconds in 30 days.

Is this possible? I was trying to find a way to have this calculation displayed but cannot seem to create a report based on this math calculation.

Thanks,

Peter

[Alex224]

Hi, can you elaborate on what is your "by month sum+" statement? I'm trying to create the same but am not following that line. 

[AishwaryaS1]

@tanvi deshpande can you please share the screenshots for this, so that I can refer them?

[Rahul Talreja]

Hi Peter,

If you are using performance analytics than this can be achieved by creating indicator source, indicator and a formula indicator. 

In formula Indicator you can calculate the difference and than convert it into percentage.

Regards,
Rahul