Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a point, I want to calculate the interval between 2 dates for each ID.
For example I want to have the interval where Status=S1 and Status=S6, so 04/12/2019 - 06/12/2019.
But the status will be changed based on input variable.
A solution is to create a new Date field for each status in Load Script, but I want to sort out in a different way.
Thanks in advance!
The result is correct in the table but if I want to show it in a BarChart or TextBox, Only() is not working properly because aggregate at the lowest level.