how to create this average by year, but monthly

[rcandeo]

I have to create a char like the image where I bring the year average but aggregated monthly

The below expression works but for a fixed year. If I put this expression in a bar chart it does not work cause brings to me the average for just the initial year, not showing year by year and I cannot find why.

avg(aggr(sum({1<FAT_LNPROD={'DOB'},FAT_MONTH=>} FAT_QUANT), FAT_MONTH))

[lironbaram]

hi

your expression seems ok

if don't make any selections in your app does it works ?

you can try to add the set expression both to the aggr function and the external avg function

like this

avg({1<FAT_LNPROD={'DOB'},FAT_MONTH=>} aggr({1<FAT_LNPROD={'DOB'},FAT_MONTH=>} sum({1<FAT_LNPROD={'DOB'},FAT_MONTH=>} FAT_QUANT), FAT_MONTH))

[sunny_talwar · Accepted solution]

Try this may be

Avg({1} Aggr(Sum({1<FAT_LNPROD = {'DOB'}, FAT_MONTH>} FAT_QUANT), FAT_MONTH, FAT_YEAR))

[rcandeo]

This is perfect, thank you so much

[rcandeo]

unfortunatelly it did no work, but thank you for your try