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

Question & Answer
1

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!

2

Hi,

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

I hope this helps!

Thanks,
Tejal Gohil