Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I have to pick date where row_id is maximum .
Date Row_id Message
1/11/2019 12:00:00 1 Data Error
1/11/2019 12:10:00 2 Data Refreshed
I want to display second row . I tried max as script function but didn't work
Thanks
Avneet
Variable overview its says 2 for max_row_id wich is correct and it shows correct for date as well.
But for message it is not. Do KPI shows Text data .
That is good, try to put single quotes around the variable ='$(max_row_id )'
Jordy
Climber
Please try the below expression :
=only({<Row_id={$(=max(Row_id))}>}Date)
Thanks it worked.