Forum Discussion
12 Months rolling average
Hi Community,
I have a table name caseid and casedatevalue.
I need to have 12 month rolling average for every month.
In the below image, it is just doing rolling average but I need 12 months rolling avergae.
For eXAMPLE : For Feb.,2023 it must do sum casecount(feb2023+last11months till march 2022)/12 = 62/12 = 5.1666
Same for January 2023, it must do sum casecount(jan2023+last11months till feb 2022)/12 = 78/12 = 6.5
October 2022, Nov 2022 most probably can't have the same same average as for Oct 2022(It will be Oct 2022+last 11 months till nov 2021)/12.
Request your kind support. I will be available at your convenience.
Thank you Community!
| CaseId | CaseDateValue |
| 22263 | 12/24/2022 0:00 |
| 22329 | 2/13/2023 0:00 |
| 22359 | 12/5/2022 0:00 |
| 72568 | 12/31/2022 0:00 |
| 77068 | 12/21/2022 0:00 |
| 78229 | 12/6/2022 0:00 |
| 78845 | 12/7/2022 0:00 |
| 78865 | 12/12/2022 0:00 |
| 81065 | 12/8/2022 0:00 |
| 82779 | 3/1/2023 0:00 |
| 82790 | 1/1/2023 0:00 |
| 85145 | 1/30/2023 0:00 |
| 87673 | 1/20/2023 0:00 |
| 90930 | 1/1/2023 0:00 |
| 91137 | 6/1/2023 0:00 |
| 93634 | 1/30/2023 0:00 |
| 93785 | 1/1/2023 0:00 |
| 94605 | 1/1/2023 0:00 |
| 95672 | 12/8/2022 0:00 |
| 96195 | 12/21/2022 8:31 |
| 96284 | 1/1/2023 0:00 |
| 96412 | 1/1/2023 0:00 |
| 96416 | 1/1/2023 0:00 |
| 96421 | 1/1/2023 0:00 |
| 96422 | 1/1/2023 0:00 |
| 96423 | 1/1/2023 0:00 |
| 96424 | 1/1/2023 0:00 |
| 96426 | 1/1/2023 0:00 |
| 96427 | 1/1/2023 0:00 |
| 96429 | 1/1/2023 0:00 |
| 96431 | 1/1/2023 0:00 |
| 96432 | 1/1/2023 0:00 |
| 96434 | 1/1/2023 0:00 |
| 96435 | 1/1/2023 0:00 |
| 96436 | 1/1/2023 0:00 |
| 96437 | 1/1/2023 0:00 |
| 96842 | 1/1/2023 0:00 |
| 96847 | 12/27/2022 10:34 |
| 96875 | 1/1/2023 0:00 |
| 96990 | 1/1/2023 0:00 |
| 97096 | 12/1/2022 0:38 |
| 97099 | 12/1/2022 0:00 |
| 97104 | 12/1/2022 11:59 |
| 97106 | 12/1/2022 0:00 |
| 97109 | 12/1/2022 12:51 |
| 97128 | 12/1/2022 0:00 |
| 97146 | 12/1/2022 13:00 |
| 97152 | 12/1/2022 12:12 |
| 97158 | 12/1/2022 18:54 |
| 97199 | 12/1/2022 0:00 |
| 97200 | 12/1/2022 0:00 |
| 97201 | 12/1/2022 0:00 |
| 97202 | 12/2/2022 0:00 |
| 97204 | 12/2/2022 10:08 |
| 97214 | 12/2/2022 8:01 |
| 97251 | 12/2/2022 11:50 |
| 97252 | 12/2/2022 17:00 |
| 97257 | 12/2/2022 0:00 |
| 97266 | 12/2/2022 0:00 |
| 97269 | 12/2/2022 14:09 |
| 97270 | 12/2/2022 0:00 |
| 97271 | 12/2/2022 14:21 |
| 97280 | 12/2/2022 15:45 |
| 97283 | 12/2/2022 0:00 |
| 97287 | 12/1/2022 0:00 |
| 97308 | 12/2/2022 0:00 |
| 97322 | 12/4/2022 22:58 |
| 97328 | 12/2/2022 11:00 |
| 97331 | 12/5/2022 0:00 |
| 97339 | 12/12/2022 0:00 |
| 97341 | 12/19/2022 0:00 |
| 97342 | 12/1/2022 0:00 |
| 97354 | 12/5/2022 15:28 |
| 97357 | 12/5/2022 15:32 |
| 97360 | 12/1/2022 0:00 |
| 97381 | 12/5/2022 0:00 |
| 97403 | 12/1/2022 0:00 |
| 97409 | 12/5/2022 0:00 |
| 97415 | 12/1/2022 15:38 |
| 97416 | 12/5/2022 0:00 |
| 97417 | 12/5/2022 0:00 |
| 97418 | 12/5/2022 0:00 |
| 97422 | 12/5/2022 16:58 |
| 97423 | 12/5/2022 17:05 |
| 97424 | 12/5/2022 0:00 |
| 97433 | 12/5/2022 0:00 |
| 97436 | 12/6/2022 6:41 |
| 97437 | 12/6/2022 6:44 |
| 97438 | 12/2/2022 0:00 |
| 97439 | 12/2/2022 0:00 |
| 97440 | 12/2/2022 0:00 |
| 97443 | 12/1/2022 7:02 |
| 97444 | 12/1/2022 7:05 |
| 97445 | 12/6/2022 11:35 |
| 97447 | 12/1/2022 0:00 |
| 97448 | 12/1/2022 7:16 |
| 97449 | 12/6/2022 7:20 |
| 97451 | 12/6/2022 7:34 |
| 97456 | 12/3/2022 0:00 |
| 97464 | 12/6/2022 0:00 |
1 Reply
miTutorialsSuper User
You can create Rolling Average using the Quick Measure function.. Please see the tutorial below for the details..