Hi,
I have a table where I am calculating the rolling average of a data series with each collum at different roll lengths (Collumn 1 is 1 second, 2 is 2 second etc.)
I have the values for all the averages in the total using the max of expression total mode in the total row of the straight table. What I want to do is plot these maximum values in a line chart accross the roll length to show decrease/increase as the time period increases. I've tried using variables but had no joy. I have put the expression I'm using and an image of the table below.
Any ideas would be greatly appreciated!!!
rangesum
(above([Power per revolution W],0,1 )) / 1
rangesum
(above([Power per revolution W],0,2 )) / 2
etc.
Cheers
Matt