Previous 30 rows average

[ecabanas]

Hi,

I would like to have the last 30 rows average froma table, any idea?

thank's

[swuehl · Accepted solution]

in you straight table chart, try something like

=rangeavg( below( sum(TotalOrders), 1, 30) )

replacing sum(TotalOrders) with your expression.

[ecabanas]

Manyyyy thank's