Rate function alternatives

[#1]

Hello,

Would be very grateful if somebody helps me solving following task, as my knowledge isnt enough and for the past week i am out of ideas how to slove it.

I have table with columns:

ID; Name and timestamp:

I need to rate timestamps inside Name dimensions, so the first timestamp is always 0 (1 is ok also).

Example:

ID                  Name       Timestamp          Rating

bosk1nxxx     bosk1n     40745.534          0

bosk1nxxx     bosk1n     40745.534          0

bosk1nxxx     bosk1n     40747.534          1

bosk1nxxx     bosk1n     40747.534          1

nikoxxx          niko         40747.534          0

nikoxxx          niko         40747.534          0

nikoxxx          niko         40748.834          1

nikoxxx          niko         40749.834          2
etc.

I've tried different options like with rank() function, RANK( TOTAL <Name> Timestamp), above(), before() functions. Combinations of peek, previous functions. But couldnt solve this task. I am kind of despered, cause i know the answer is somewhere close, but i cannot solve it. Could somebody help?

Attaching table just in case.

[lironbaram · Accepted solution]

hei

attach is an example doing it in the load script

hope its helps you

[#3]

Thanks a lot Liron! Looks like that's exactly what I was looking for. You've ended my tortures

And thanks for learning me new useful function numsum()