Forum Discussion
12 Months rolling average
Hello Community, I hav a table (Case) with : 1. Case ID 2. Casedatevalue which contains date and is of date type I want to have count of case id by month and also rolling average for 12 mon...
Ashish_Mathur The average are correct. But as it is 12 month rolling average for example Feb 2023, it should go back 11 month adds the counts from March 2022 to Feb 2023 (62) and divide by 12 which will be 5.16666.
As per your explanation it is doing rolling average but not considering 12 month rolling average for example for Feb 2023 it is summing the count from Jan 2022 to feb 2023.
Ashish_Mathur
Super User
Super User