Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Expert,
How to get day difference based on condition?
Interval between day 3 H1 to day 18 H1 is 15
Thanks for the help,
i managed to get the result by using Previous - script function.
LOAD
*,
IF([Location] = PREVIOUS([Location]),[Date] - PREVIOUS([Date])) AS Interval
RESIDENT [Sheet2]
ORDER BY [Location]
;
DROP TABLE [Sheet2];
how do you get that?
can you elaborate ?
Hi Shraddha,
[Date] - [Date] = Interval
18 - 3 = 15
can you share sample app?
Thanks,
Sure, please refer attached.
Thanks for the help,
i managed to get the result by using Previous - script function.
LOAD
*,
IF([Location] = PREVIOUS([Location]),[Date] - PREVIOUS([Date])) AS Interval
RESIDENT [Sheet2]
ORDER BY [Location]
;
DROP TABLE [Sheet2];