Average of data within a range of percentiles

[schmidtj]

Hi,

i have the following set of data (see attachment):

A dimension '_id' with a value 'durationSeconds'.

Furthermore i calculated the percentile of each row like this:

rank(Total - durationSeconds, 3)/count(Total durationSeconds)

My goal is now to:

calculate the average of the values, however only among those rows, where the percentile is <= 0.8.

However, integrating the formular for the average is not allowed

(Rank function is not allowed inside aggregation)

Avg(if(rank(Total - durationSeconds,3)/count(Total durationSeconds) <= 0.8, durationSeconds))

Can anybody help me with this problem?

Thanks a lot.

[marcus_sommer]

The problem isn't the rank() else that you nest aggregations without using aggr(). Take a look here: AGGR.

- Marcus

[schmidtj]

Ok ill have a loot at that.

Thanks.