Forum Discussion
6 Week Rolling Average
I need to calculate a six week rolling average with duplicates of product ID removed before calculating the average. I have looked at lots of other people's posts about similar situations which is ho...
Hi lbendlin , hopefully this sample data helps. I appreciate the help.
| Product ID | Sold | Customer | Date |
| 2010 | 331 | A | 7/10/2023 |
| 1776 | 471 | B | 7/11/2023 |
| 2908 | 603 | A | 7/12/2023 |
| 2474 | 620 | C | 7/13/2023 |
| 2892 | 341 | C | 7/13/2023 |
| 1824 | 302 | B | 7/17/2023 |
| 2597 | 581 | B | 7/18/2023 |
| 2483 | 335 | A | 7/18/2023 |
| 2682 | 240 | A | 7/20/2023 |
| 1203 | 284 | C | 7/21/2023 |
lbendlin
Super User
Super UserNot really. If you want a 6 week rolling average you need to provide at least 7 but better 12 or more weeks of sample data.