Forum Discussion
Rolling Average
Hello, I've been reading a lot on this and tried so many different permutations but can't get it to work. Goal: I am trying to plot a moving average for 'delays' against date. Here is my raw ...
Hello,
I've managed to reproduce my data, please see below. The first table is the raw data and the second table is what I'm hoping to achieve in powerapps but have been so far unsuccsessful:
Raw Data
| delay_end | delay_length |
| 17/10/2017 | 25 |
| 17/10/2017 | 10 |
| 23/10/2017 | 60 |
| 23/10/2017 | 60 |
| 24/10/2017 | 100 |
| 26/10/2017 | 5 |
| 26/10/2017 | 40 |
| 26/10/2017 | 10 |
| 26/10/2017 | 20 |
| 26/10/2017 | 20 |
| 27/10/2017 | 15 |
| 26/10/2017 | 10 |
| 28/10/2017 | 30 |
| 28/10/2017 | 10 |
| 28/10/2017 | 10 |
| 30/10/2017 | 20 |
| 30/10/2017 | 390 |
| 01/11/2017 | 20 |
| 03/11/2017 | 30 |
| 06/11/2017 | 20 |
| 06/11/2017 | 130 |
| 06/11/2017 | 120 |
| 06/11/2017 | 90 |
| 06/11/2017 | 40 |
| 09/11/2017 | 35 |
| 09/11/2017 | 15 |
| 09/11/2017 | 15 |
| 16/11/2017 | 15 |
| 17/11/2017 | 190 |
Average calculated as =sum(last 5 days delay)/5
| delay_end | delay_length | delay_length_average |
| 17/10/2017 | 35 | |
| 18/10/2017 | 0 | |
| 19/10/2017 | 0 | |
| 20/10/2017 | 0 | |
| 21/10/2017 | 0 | 7 |
| 22/10/2017 | 0 | 0 |
| 23/10/2017 | 120 | 24 |
| 24/10/2017 | 100 | 44 |
| 25/10/2017 | 0 | 44 |
| 26/10/2017 | 105 | 65 |
| 27/10/2017 | 15 | 68 |
| 28/10/2017 | 50 | 54 |
| 29/10/2017 | 0 | 34 |
| 30/10/2017 | 410 | 116 |
| 31/10/2017 | 0 | 95 |
| 01/11/2017 | 20 | 96 |
| 02/11/2017 | 0 | 86 |
| 03/11/2017 | 30 | 92 |
| 04/11/2017 | 0 | 10 |
| 05/11/2017 | 0 | 10 |
| 06/11/2017 | 400 | 86 |
| 07/11/2017 | 0 | 86 |
| 08/11/2017 | 0 | 80 |
| 09/11/2017 | 65 | 93 |
| 10/11/2017 | 0 | 93 |
| 11/11/2017 | 0 | 13 |
| 12/11/2017 | 0 | 13 |
| 13/11/2017 | 0 | 13 |
| 14/11/2017 | 0 | 0 |
| 15/11/2017 | 0 | 0 |
| 16/11/2017 | 15 | 3 |
| 17/11/2017 | 190 | 41 |
I hope that makes more sense now and someone will be able to help.
I need to solve exactly the same issue. Have you found a sollution?