Hi i want to achieve a table like below.
I have already the Sec and the value, and i want to create a new column thats takes the larges "value" from column 2 over +/- 5 rows as below.
How can i do that in alteryx? i have 44k rows
| Sec | Value | Max over +/- 5 rows |
1 | 2 | 4 |
2 | 2 | 9 |
| 3 | 3 | 9 |
| 4 | 3 | 9 |
| 5 | 4 | 9 |
| 6 | 5 | 9 |
| 7 | 9 | 9 |
| 8 | 3 | 9 |
| 9 | 4 | 9 |
| 10 | 7 | 9 |
