Dear All ,
How to do statistic report on on rolling 12 month basis , e.g on 1/1/2019 , we need the sum and count from 1/1/2018 till 1/1/2019 and so on .
Thanks ,
Dear All ,
How to do statistic report on on rolling 12 month basis , e.g on 1/1/2019 , we need the sum and count from 1/1/2018 till 1/1/2019 and so on .
Thanks ,
I would
https://knowledge.safe.com/questions/102959/incorrect-results-from-statisticscalculators-cumul.html
Thanks @ebygomm for the support but it is not adding the previous month . the output should be as rolling12month output
Thanks @ebygomm for the support but it is not adding the previous month . the output should be as rolling12month output
I misread, I think you don't need the group by at all in that case, and then just keep the output for the first of each month