Dataset data : extremum

Get Help
1

Hi again,

I’m trying to use a dataset where you put the date of the entry and a few other data, and I want to display the most recent data.
Since there doesn’t seem to clearly be the name of the table on the filters, how do you select the line of data with the max (or the min) of a value ? I’ve tried things like “myDate=MAX(MyDate)” and "(Select DATE(MyDate)) = MAX (SELECT DATE(MyDate)) but of course it didn’t work

Thank you.
Mehdi.

2

The easiest way would probably be to set the Order by MyDate Descending and set upper row limit to 1.

That’s assuming MyDate is the column with date and that you want to show only the row with newest date.

3

Sorry for the late answer !

Thank you, it worked. Not very intuitive though :confused:

Have a good day !

Mehdi