I have a table as follows:
And I have to make a calculation as follows:
( (Date_Time) - (Previous Date_Time) ) * Rolling Time
I've found a way for this calculation but in some cases some record is not picking the correct Previuos Date_Time.
Can anyone suggest a way for this calculation? This can be done in the script or in QlikSense Application.
Thanks in advance!!