Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average of last three Orders

I want to graph:

      - Dimension: Month

     - Expression: Average Order size of last three orders in that month.

I came to

Aggr(avg(OrderSize),Order)

Now how do i get it to only calculate the last three Orders of that month?

I read about FirstSortValue, but i am not sure how to use it in this context.

Jarl.

0 Replies