Get sorted values

[krzohi]

Hi all,

i need to get TOP 3 of sorted values to make separate tables and also use those values for next filtering

I tied to use FirstSortedValue() but it sorting only by unique values, so on output i got rows 1,2,4 from my example.

Thanks in advance.

[sunny_talwar]

Would you be able to share the expression you have used?

[krzohi]

I think i solve my problem by adding 'timestamp' to 'value' to have uniqe value for sorting:

FirstSortedValue( timestamp, - value + timestamp)

[krzohi]

Hi, 

i have another problem right now which i missed before. I want rows as in previous example, table had two sorts, first by 'value' and second by 'timestamp' descending, so that i was able to get on output the newest highiest values.

The issue is that in function FirstSortedValue() i cannot set second sorting (by default 'timestamp' is sorted ascending). 

Oddly as i use FirstSortedValue( timestamp, - value + timestamp), the 'timestamp' in 3rd row is bigger so sorting by value + timestamp  should be as i expect, but no..

[krzohi · Accepted solution]

Ok, i solve it.. value + timestamp should be in brackets: 

FirstSortedValue( timestamp, - (value + timestamp))