Get last x value of column partitioned by data and order (LastOver?)

Hello everyone! Lets say I have data with attributes timestamp, order_id, status_a and status_b.
How can i get the latest value of status_a by orer_id with timestamp ASC. I tried LastOver but it doesnt allow me to insert it into my table visual. Please help!


You can use lastValue() function.
Example: lastValue(status_a, [timestamp ASC], [order_id])

I hope this helps!

Tejal Gohil