How to refer to the data in the row with the maximum value in a field

Question & Answer
,
1

I want to get the value of the row whose field has the maximum value(※equal latest date).
following example,3 in the f is maximum value,so I want to get 140

image
※x field is integer calculated from json string data

my try
1, max(f,[{x}]) →in graph “no surpport” or 1 argument

2, lastValue(x,[f ASC]) → in graph “reference not found”

2

Hi @techtech1919
you only want the single f value?
BR

3

I want the x value when f is maximum.

4

What if using a rank function and filter on rank=1?

5

my try
rank([max(f) ASC],[{x}])
in graph → “no reference”

Are there any other settings required?

6

solved.

I couldn’t use filter.
But field change “Convert to dimension”,I get data when f was at its maximum value.

I appreciate for you.

7

Ok. Could you please solve the topic?

1 Like