Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Try this may be
Avg({1} Aggr(Sum({1<FAT_LNPROD = {'DOB'}, FAT_MONTH>} FAT_QUANT), FAT_MONTH, FAT_YEAR))
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))
Try this may be
Avg({1} Aggr(Sum({1<FAT_LNPROD = {'DOB'}, FAT_MONTH>} FAT_QUANT), FAT_MONTH, FAT_YEAR))
This is perfect, thank you so much
unfortunatelly it did no work, but thank you for your try