Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
could you please help me with this?
This is my table:
and this is what I would like to get:
For A last day (max) and the lowest number on that day(min).
I already tried these:
for date max(date) and for value if (max(date)=date, min(L,R)), but it doesn't work. Or in case only max(date) and min(L,R) I get last date, but lowest number for all measurements. In case of C 01/01/2018 value:1010, but this is not the lowest on that day.
Thanks for your help!
May be these two expressions
Max(Date)
FirstSortedValue(RangeMin(L, R), -Date)
If you want to handle it at the script level, check this.
This doesn't seem right
I think you wanted to do this
LOAD Field, Date(Max(Date), 'DD/MM/YYYY') as MaxDate, FirstSortedValue(MinM, -Date) as MinNum
Resident t1 Group by Field;
Min(MinM) will find the Min regardless of the max date, where as OP seems to need the min between L or R for the max date
Thanks for correcting it . i missed it.