Agregation on only first few values

[paweln]

Dear All,

imagine a table like this:

I have to:

1. Calculate  average on first (the oldest) 5 values.

2. Calculate average for first (the oldest) 2 values for specific month, lets say March.

dates will be changing so I can't simply use set expression and fix dates to get first values.

[Chanty4u]

try this

 for first   "=aggr(if(rank(avg(value))<=5,Date),Date) "

for second:  "=aggr(if(rank(avg(value))<=2,Month),Month) "    ( month you need to derive from date field)

[paweln]

I have tried the first one so far but it looks like it returns date, not average value.

[sunny_talwar]

@paweln May be this for first one

Avg(Aggr(If(date >= Max(TOTAL date, 5), value), date)

For Second, will you be selecting a month or do you want it to be passed in as set analysis?