Analytical functions > more details regarding "average"

Previous Member

Hi,

 

I would like to use one of the availableanalytical functions : average

According to the help,

Average: it returns the average value of the series (Total/Time Length);

Can anyone give more details on how the average calculation works ?

• how happens the aggregations ?
• Does the function apply after all aggregations and context selections of the screen and layout ?

 

I have tried an example of average calculation and get different result depending on using the analytical function or not:

 

1. V001 one cube by {Day, Country, Claim, Model} having the total costs
2. V004 one counter cube having the same dimensions (MXC)
   
3. the sparsity is:
4. dataview context: no selections, no pagers, nothing
5. layout:
   1. blocks a and d uses V001, block b uses V004.
   2. Country set by row
   3. Average analytical function on block d.
   4. nothing else special
6. the dataview looks like this:
7. i would have expected to see the same values for blocks c and d, e.g. for IT: 203 € and not 968 €

 

I might have not understood the scope of the average function within the analytical function.

Could someone help me understanding it better ?

 

Thanks in advance,

Björn Reuber

Hi,

 

Your comparing the result an a "wrong" level. The MXC is using a disitinct count (so without having a real mathematical prove it will count the distinct claims on country [?] level], while the average is only calculated for a time period. Furthermore without knowing the time period (should the average in block d be on daily, monthly, yearly base?). Its hard to tell the correct result.

 

Which average do you expect? Just add the time period for your analysis to "by Row" and use the total feature average to see the correct value.

 

regards

Björn