Calculate sum of two fields from two different table

[Wendy Kuo]

Hi, 

I am trying to report on impacted minutes, which essentially is the total minutes resulted from degradation and outages (excluding downtime outside of availability window). Currently in the outage table, it would include outage and degradation records. However the duration for the outage records include the entire downtime and does not exclude downtime that happens outside the availability window. To get the accurate downtime for the outage, I have to get this from the Commitment downtime in the service available table. So to capture total impact minutes, I need to create two reports, one for degradation, which sums up the duration field using outage table, and one for outage which sums up Commitment downtime using service availability table. As there's still manual work require because I need to manually sum up the minutes from both reports. Is there a way that I can calculate the impacted minutes in one report?

[jonsan09]

You could try using Performance Analytics to setup an automated indicator to collect the data from each field and then use a formula indicator to add the indicators together.

[Tai Vu · Accepted solution]

Hi @Wendy Kuo 

If your instance has activated Performance Analytics, let's define 2 Automated Indicators.

1. SUM of Duration Outage 

2. SUM of Commitment Downtime.

Then you can define a Formula Indicator that will SUM of 2 Automated Indicators above. Sample.

[[SUM of Duration Outage]] + [[SUM of Commitment Downtime]]

Cheers,

Tai Vu

[Wendy Kuo]

Thank you all. This is helpful