Previous Topic: Custom Aggregation Reporting OptionsNext Topic: Calculation Method: Average of Time, Average of Contract


Calculation Method: Average of Contract, Average of Time

This method of calculating the deviation can be used when you want to emphasize the time that a certain deviation reading took place, while disregarding the contract to which the data relates.

This calculation is performed in two steps:

Step 1: Average of Contract

In this step, the calculation disregards the differences in the contract column of the raw data (Contract A vs. Contract B), and instead groups the raw data according to the time at which the reading was taken.

Time

Domain Category

Deviation

Calculation

00:00:00

Category A

20

avg (10,30)

00:10:00

Category A

60

avg (60)

00:20:00

Category A

-15

avg (– 15)

01:00:00

Category A

20

avg (20)

Step 2: Average of Time

In this step, the deviation is calculated by taking the average for each time period, as aggregated in the previous step:

average (20, 60, -15, 20) = 21.25