The average of totals for each month

[TeodoraBurlica]

Hi,

I want an average of the totals per month,  only for the months from the beginning of the year until the current one (Jan-Mar).  This needs to be independent of selections.

I tried this but it only works if I have the 3 months selected:

avg(total aggr(sum({<Year = {'2023'}, DATE_PICKER=>} Value), Month))

Do you have any idea?

Thanks 

[rpennacchi]

Can you try to do this:

RangeAvg({<DATE_PICKER>}above(total sum({<Year = {'2023'}>}Value),0,12))

However, because you said this table is independent of any the selection, my suggestion is to create this table on your script so you don't need to make calculations on your visualization and your app will be faster.