| stats earliest(rank) as earliest_rank latest(rank) as latest_rank by user
| eval final_rank = latest_rank-earliest_rank
| table user final_rank
Have you more than two times/ranks for particular user and are there at least two ranks per user?
r. Ismo
Yes, same user can have more than two times/ranks.
Solution sugjested byt thambisetty takes that into account and works perfectly.
Thanks
| stats earliest(rank) as earliest_rank latest(rank) as latest_rank by user
| eval final_rank = latest_rank-earliest_rank
| table user final_rank