calculate a year average

[#1]

Dear all,

I have a problem to calculate a year average.

I have four date field:

=> YEAR

=> MONTH

=> DAY

=>AMOUNT

If I set a filter for example Year = 2016, Month = 11 and Day=28

I get only the amount for the date 28.11.2016

At the same time I want to have a year average to my "Year" Filter.

So that I have two values.

The first value ist der amount for the date 28.11.2016

and the second vaule should be the yaer average for 2016.

Thanks a lot for your help.

Best regards

Björn

[sunny_talwar · Accepted solution]

You can ignore selections in Month and Day for your second expression

Avg({<Month, Day>}Value)

This will now show your the Avg value for 2016 excluding any selections you might have made in Month or Day field.