Forum Discussion
Rolling 28 Day Measure
A version of this question has been asked numerous times, but I still cannot figure it out from all the other examples. I am trying to calculate a rolling 28 day count of responses. A view of my...
Here is my data again in an easier format to consume.
| EventDate | Service | IsUserInternal | Prompts | Responses | CommentCount |
| 2019-10-22 00:00:00.0000000 | Boards | 0 | 1296 | 91 | 13 |
| 2019-10-22 00:00:00.0000000 | Boards | 1 | 247 | 12 | 1 |
| 2019-10-23 00:00:00.0000000 | Boards | 0 | 1233 | 90 | 10 |
| 2019-10-23 00:00:00.0000000 | Boards | 1 | 196 | 9 | 0 |
| 2019-10-24 00:00:00.0000000 | Boards | 0 | 1200 | 93 | 14 |
| 2019-10-24 00:00:00.0000000 | Boards | 1 | 205 | 5 | 1 |
| 2019-10-25 00:00:00.0000000 | Boards | 0 | 1055 | 75 | 14 |
| 2019-10-25 00:00:00.0000000 | Boards | 1 | 193 | 5 | 1 |
| 2019-10-26 00:00:00.0000000 | Boards | 0 | 70 | 11 | 4 |
| 2019-10-26 00:00:00.0000000 | Boards | 1 | 38 | 1 | 0 |
| 2019-10-27 00:00:00.0000000 | Boards | 0 | 105 | 7 | 2 |
| 2019-10-27 00:00:00.0000000 | Boards | 1 | 13 | 0 | 0 |
| 2019-10-28 00:00:00.0000000 | Boards | 0 | 1286 | 92 | 16 |
| 2019-10-28 00:00:00.0000000 | Boards | 1 | 175 | 3 | 0 |
| 2019-10-29 00:00:00.0000000 | Boards | 0 | 1232 | 93 | 11 |
| 2019-10-29 00:00:00.0000000 | Boards | 1 | 206 | 11 | 0 |
| 2019-10-30 00:00:00.0000000 | Boards | 0 | 1280 | 93 | 18 |
| 2019-10-30 00:00:00.0000000 | Boards | 1 | 192 | 10 | 3 |
| 2019-10-31 00:00:00.0000000 | Boards | 1 | 204 | 9 | 1 |
| 2019-10-31 00:00:00.0000000 | Boards | 0 | 1196 | 89 | 8 |
| 2019-11-01 00:00:00.0000000 | Boards | 0 | 887 | 66 | 12 |
| 2019-11-01 00:00:00.0000000 | Boards | 1 | 188 | 6 | 0 |
| 2019-11-02 00:00:00.0000000 | Boards | 0 | 77 | 4 | 1 |
| 2019-11-02 00:00:00.0000000 | Boards | 1 | 23 | 1 | 0 |
| 2019-11-03 00:00:00.0000000 | Boards | 0 | 106 | 7 | 0 |
| 2019-11-03 00:00:00.0000000 | Boards | 1 | 16 | 1 | 0 |
| 2019-11-04 00:00:00.0000000 | Boards | 0 | 1358 | 92 | 9 |
| 2019-11-04 00:00:00.0000000 | Boards | 1 | 216 | 9 | 1 |
| 2019-11-05 00:00:00.0000000 | Boards | 1 | 228 | 4 | 0 |
| 2019-11-05 00:00:00.0000000 | Boards | 0 | 1368 | 120 | 18 |
| 2019-11-06 00:00:00.0000000 | Boards | 0 | 1250 | 88 | 17 |
| 2019-11-06 00:00:00.0000000 | Boards | 1 | 216 | 10 | 1 |
| 2019-11-07 00:00:00.0000000 | Boards | 0 | 1250 | 87 | 20 |
| 2019-11-07 00:00:00.0000000 | Boards | 1 | 205 | 8 | 0 |
| 2019-11-08 00:00:00.0000000 | Boards | 0 | 1069 | 78 | 16 |
| 2019-11-08 00:00:00.0000000 | Boards | 1 | 180 | 9 | 1 |
| 2019-11-09 00:00:00.0000000 | Boards | 1 | 29 | 0 | 0 |
| 2019-11-09 00:00:00.0000000 | Boards | 0 | 81 | 6 | 3 |
| 2019-11-10 00:00:00.0000000 | Boards | 1 | 15 | 2 | 0 |
| 2019-11-10 00:00:00.0000000 | Boards | 0 | 99 | 9 | 1 |
| 2019-11-11 00:00:00.0000000 | Boards | 1 | 211 | 7 | 0 |
| 2019-11-11 00:00:00.0000000 | Boards | 0 | 1219 | 73 | 11 |
| 2019-11-12 00:00:00.0000000 | Boards | 0 | 1359 | 104 | 20 |
| 2019-11-12 00:00:00.0000000 | Boards | 1 | 204 | 8 | 2 |
| 2019-11-13 00:00:00.0000000 | Boards | 0 | 1284 | 84 | 19 |
| 2019-11-13 00:00:00.0000000 | Boards | 1 | 199 | 10 | 2 |
| 2019-11-14 00:00:00.0000000 | Boards | 0 | 1218 | 100 | 17 |
| 2019-11-14 00:00:00.0000000 | Boards | 1 | 215 | 5 | 1 |
| 2019-11-15 00:00:00.0000000 | Boards | 1 | 162 | 3 | 0 |
| 2019-11-15 00:00:00.0000000 | Boards | 0 | 1000 | 78 | 13 |
| 2019-11-16 00:00:00.0000000 | Boards | 0 | 108 | 12 | 1 |
| 2019-11-16 00:00:00.0000000 | Boards | 1 | 32 | 2 | 1 |
| 2019-11-17 00:00:00.0000000 | Boards | 0 | 112 | 9 | 0 |
| 2019-11-17 00:00:00.0000000 | Boards | 1 | 23 | 2 | 0 |