topic 2nd or 3rd highest value in App Development

2nd or 3rd highest value

Anonymous — Wed, 20 Dec 2017 16:01:38 GMT

I have a list of categories each with an average score 'avg(EasyScore)'. I can use the first sorted value to generate the category with the highest average score but is there a way of getting the 2nd, 3rd or nth highest score. Maybe a combination of rank and agrr? The category field is 'SubSubCategory'.

Re: 2nd or 3rd highest value

marcus_sommer — Wed, 20 Dec 2017 16:14:00 GMT

By firstsortedvalue() and by max() could by using the fourth respectively second parameter any other value be returned.

- Marcus

Re: 2nd or 3rd highest value

Anonymous — Thu, 21 Dec 2017 09:10:09 GMT

FirstSortedValue(SubSubCategory, -aggr(avg(EasyScore),SubSubCategory)) would give me the highest SubSubCategory by EasyScore. Where would i use max to give me the second highest?

Re: 2nd or 3rd highest value

marcus_sommer — Thu, 21 Dec 2017 09:18:59 GMT

The logic is:

firstsortedvalue(ReturnField, LookupExpression, SortField, RankNumber)

max(Field, RankNumber)

- Marcus