topic how to create this average by year, but monthly in App Development

how to create this average by year, but monthly

rcandeo — Mon, 05 Nov 2018 13:43:48 GMT

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))

Re: how to create this average by year, but monthly

lironbaram — Mon, 05 Nov 2018 13:47:10 GMT

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))

Re: how to create this average by year, but monthly

sunny_talwar — Mon, 05 Nov 2018 13:47:47 GMT

Try this may be

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

Re: how to create this average by year, but monthly

rcandeo — Mon, 05 Nov 2018 14:04:32 GMT

This is perfect, thank you so much

Re: how to create this average by year, but monthly

rcandeo — Mon, 05 Nov 2018 14:08:58 GMT

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