Apologies if this already answered elsewhere but I couldn’t find it anywhere.
I am trying to find the interval between the last 2 purchases each customer has made.
I am able to find the earliest timestamps by counting up and can find the very last purchase by using ‘last’, but have been unable to find a way to ‘count backwards’ and find the second to last purchase etc.
Does anyone have any idea how this would be possible?