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 ,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+44- Influencer
- 3427 replies
I would
- Create a new attribute with the date converted to a month/year format only, e.g. 1/2018.
- Ensure that your data is sorted in date order
- Send to the statistics calculator with a group by on the newly created month year attribute
- Use the cumulative output (be aware that there may be a workaround required to get round an issue with the statistics calculator)
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
+44- Influencer
- 3427 replies
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