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:
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) |
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
|
Copyright © 2012 CA.
All rights reserved.
|
|