Forum Discussion

Anonymous

Not applicable

5 years ago

Unique timeline from the overlapping time stamp

Hello Everyone, I am trying to summarize the timeline of resources who are logging in 'downtime' for the applications. The details from the PowerApps is captured in the below format: Employe...

Need Help

Anonymous

Not applicable

5 years ago

Hello Allan,

Thanks for the above solution, however it is not creating a unique timeline from the overlapping timestamp.

If you look at the table, the actual "downtime" for resource 1 on 4th February across four instances is only 5 minutes (as all the time stamp for resource 1 on 4th Feb is repeating between 3.35 pm and 3.40 pm, however, the result is showing 20 minutes which is misleading for the manager as they are coming in the dashboard to identify the "Lost Productivity" due to application outage. Actual DowntimeResult Measure