Filter view based on time and status

[SKETCHwade]

My app is designed to store data long term.
So there are many rows with the same ID.
I just need it to only show the newest row of every ID, that has a specific status.

I can filter based on Status fine but I can’t think of a way to only show each ID’s latest entry

[Lynn]

Do you have a date time column? Or if all else fails could you use row number for a MAX expression.

[SKETCHwade]

Yes I do have a DateTime column. I’ll look into the MAX expression, thanks

[SKETCHwade]

@Lynn

I understand I should use something like MAX(LIST(
But I’m unsure of what the expression would look like

[Thomas_Varghese]

could use expression like
Maxrow(“tablename”,_Rownumber) and it will pick the key column which could be the ID column this your case…