Aggr result changes when I make selection date

[aronvermeulen]

The aggr function is working correct when i do not have a selection:

But when I make a selection the result is changing, I really don't understand why.

I would say the dimension is not changing, so the aggr shouldn't do either.

I can make a workaround by making the average per container in the script. 

But I would like to learn what I do wrong in this case.

[lironbaram]

when using 

aggr functions in a chart you need to include the chart\table dimension in the function 

to get the right results 

in your case you need to add your month dimension 

[aronvermeulen]

Thanks for your reply.

I already tried like below. But maybe this is not working because the used Month() and year() functions?

I rebuild it to Month (Maand) and year (Jaar).

But now the result is not correct, 2020-04 should be 2.7, not 36.

Can you tell me with this information what I am doing wrong?

[lironbaram]

hi 

it's hard 

can you share sample data , so i can understand the fields and the tables structure 

it can be 2-3 rows from each table , i'll put more demo data to the structure 

[marcus_sommer]

Without knowing the datamodel it's difficult to say what's different to your expectation. In each case you shouldn't use such a calculated dimension neither in general nor by applying an aggr(). Just define all needed period-fields within the calendar and this means also the combination of year and month within an extra field and then use this field also within the aggr().

- Marcus