How to group events, subtract earliest rank from latest rank per user, and track value change over time?

[amoulkaf]

Hello,

Each event represents a user state and every user has rank.

data look as follow :

time	rank	user
time1	30	2
time1	50	1
time2	25	2
time2	51	1

Any idea on how to group events by time, and subtract the earliest rank from the latest rank for each user?

M

[isoutamo]

Have you more than two times/ranks for particular user and are there at least two ranks per user?

r. Ismo

[amoulkaf]

Yes, same user can have more than two times/ranks.
Solution sugjested byt thambisetty takes that into account and works perfectly.
Thanks

[thambisetty · Accepted solution]

| stats earliest(rank) as earliest_rank latest(rank) as latest_rank by user 
| eval final_rank = latest_rank-earliest_rank
| table user final_rank