Forum Discussion
Solved
Average by Week
My Data is as follows, with data going back to the start of the year
| Week | Week Start Date | Name | Emails Sent |
| 38 | 14/09/20 | Person 1 | 150 |
| 38 | 14/09/20 | Person 2 | 256 |
| 38 | 14/09/20 | Person 3 | 189 |
| 37 | 07/09/20 | Person 1 | 354 |
| 37 | 07/09/20 | Person 2 | 156 |
| 37 | 07/09/20 | Person 3 | 345 |
And I'm looking to create another column of the average emails sent per week, so it would look like the below:
| Week | Week Start Date | Name | Emails Sent | Emails Sent (Weekly Average) |
| 38 | 14/09/20 | Person 1 | 150 | 198 |
| 38 | 14/09/20 | Person 2 | 256 | 198 |
| 38 | 14/09/20 | Person 3 | 189 | 198 |
| 37 | 07/09/20 | Person 1 | 354 | 285 |
| 37 | 07/09/20 | Person 2 | 156 | 285 |
| 37 | 07/09/20 | Person 3 | 345 | 285 |
So my question is, how do I create a column which can do this?
morgancampbell , Please try a new column like
Averagex(filter(Table,[Week Start Date] =earlier([Week Start Date])),[Emails Sent])
2 Replies
morgancampbell , Please try a new column like
Averagex(filter(Table,[Week Start Date] =earlier([Week Start Date])),[Emails Sent])
Ah it worked!!
That's brilliant, thank you
