How to calculate an average of first 200 rows in a column from a table with 20000 rows.


I want to create a horizontal line expression on a column to be applied as a limit to a scatter plot.

I want to model the expression for the horizontal line so that it uses an average of the first 200 rows only. 

I tried playnig around with the last periods function in spotfire, but not getting a correct value for the line expression.

Any ideas?




(2) Answers