Forum Discussion
Anonymous
5 years agoNot applicable
Problem with Uptime Calculation
I am trying to calculate the uptime percentage with dynamic date ranges for all of my assets (Reactive Category), I have start time and end time of repairs, but I am having trouble defining availabil...
v-zhenbw-msft
5 years agoCommunity Support
Hi Anonymous ,
Sorry for that we are not clearly about your desire result.
Do you want to the difference between start and end? You can create a difference column using DATEDIFF function.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.