Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

UpTime/DownTime Calculation By Ignoring With Overlapping Time

 This is my source date . And this is my expected out put.  I have machine downtime(Start) and Uptime(End) dates. I want to calculate my uptime and downtime as shown in the ...
Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    @Syndicate_AdminFirst of all thanks for your time.

    This is working fine when I slice the data by type 0 but this is not working for type 1 (showing more than 24 hrs per day which is not expected). My main object is to calculate the down time per day which should ignore's the overlapping time.
    For example in the below example on 8/26/2020 two machines involved in the Downtime. My expected out put is 23.4 hrs(showing 42.5 because not ignoring the value 19.0) when we don't have any slicer selection but when we select something it has to show the corresponding value for that day (type 0, 23.4 hr's and type 1, 19.0 hr's).

    sivanjali_0-1610665224520.png



    sivanjali_1-1610665477305.png


    Is there any way to make it measure instead of column so we can make this calculation more dynamic in order to consider the slicers.?



  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous  Thanks for your time. But it's not working as per expectation. 

    1. When we select the slicer it should work as per selection.
    2. If none selected then it should return overall Downtime which is not more than 24 hours per day.