The use of custom aggregation reporting options is illustrated by the following example.
Example: Using custom aggregation reporting options:
Assume a report of the type Deviation by Domain Category that includes:
In this example, the remaining variables that can be used for the custom aggregation calculation steps are Contract and Time. Different results will be obtained depending on the order of calculating these two steps. In addition, both these results will differ from the default average calculation.
The raw data for the report is as follows:
|
Time |
Contract |
Domain Category |
Deviation |
|---|---|---|---|
|
00:00:00 |
Contract A |
Category A |
10 |
|
00:20:00 |
Contract A |
Category A |
-15 |
|
01:00:00 |
Contract A |
Category A |
20 |
|
00:00:00 |
Contract B |
Category A |
30 |
|
00:10:00 |
Contract B |
Category A |
60 |
When this data is calculated using the standard method of averaging all the raw data, the result is:
average (10, -15, 20, 30, 60) = 21
|
Copyright © 2013 CA.
All rights reserved.
|
|