Examples of Exception Aggregation: Average
(AV1)
You want to calculate the average of an overall value by day. The query looks like this:
From Date |
To Date |
Period of Time in Days |
Value |
Period of Time in Days Multiplied by Value |
20050618 |
20050620 |
2 |
3 |
6 |
20050620 |
20050625 |
5 |
2 |
10 |
20050625 |
20050629 |
4 |
2 |
8 |
20050629 |
20050630 |
1 |
27 |
27 |
20050630 |
20050708 |
8 |
44 |
352 |
20050708 |
20050807 |
30 |
1 |
30 |
20050807 |
20050807 |
1 |
0 |
0 |
|
Sum |
51 |
79 |
433 |
You calculate the average as follows:
433 ÷ 51 = 8.490
To get this result, the key figure must have the exception aggregation Average (AV1), relating to the characteristic Calendar Day (0CALDAY).
For a key figure with the exception aggregation Average (AV1) relating to the characteristic Calendar Month (0CALMONTH), the result is as follows:
From Date |
To Date |
Period of Time in Days |
Value |
Period of Time in Days Multiplied by Value |
200506 |
200506 |
30 |
3 |
90 |
200506 |
200506 |
30 |
2 |
60 |
200506 |
200506 |
30 |
2 |
60 |
200506 |
200506 |
30 |
27 |
810 |
200506 |
200507 |
61 |
44 |
2684 |
200507 |
200508 |
62 |
1 |
62 |
200508 |
200508 |
31 |
0 |
0 |
|
Sum |
274 |
79 |
3766 |
You calculate the average as follows:
3766 ÷ 274 = 13.744