Forum Discussion
Calculating Time Difference - Multiple Start point and Multiple End Point for Alarm in same column
Based on my understanding, Call or Assistance is the Start of Event, reset or Present or Accepted is the End of the Event,
you need to calculate the time difference between any Start of Event and any End of the Event per room, right?
For example, for room below,
| index | time | room | state | time difference(seconds) | logic | ||
| row1 | 2/1/2018 8:42 | Bedroom 3 L/G | Reset | 1 | time in row1- time in row3 | ||
| row2 | 2/1/2018 8:42 | Bedroom 3 L/G | Present | 1 | time in row2- time in row3 | ||
| row3 | 2/1/2018 8:41 | Bedroom 3 L/G | Assistance | 0 | |||
| row4 | 2/1/2018 8:39 | Bedroom 5 L/G | Reset | 1 | time in row4- time in row5 | ||
| row5 | 2/1/2018 8:38 | Bedroom 5 L/G | Call | 0 | |||
Please let me know if my logic is right so i can test and figure out for you.
Best Regards
Maggie
Good afternoon v-juanli-msft, Thank you for your email and appology for late reply as I was having an issue with logging since Microsoft Community has been moved to Azure AD integration. I must say that support from Micrsoft Community service provider was great where they have logged on to PC today and show me step by step instruction to log me back in.
Yes, your understanding is correct and logic too. However there is also another catch where Health Care Assiatnt press reset button once and it will appear as a present. If they press same button again, then and only then it will turn in to reset status.
So, summarise the case, All the alert starts with Call or Assistance and either end with Present or Reset depnding on how Health Care Assistant interact with it.
There is also another logs which says Emergency (Staff raise emergency to notify other members for help) normally ends with Reset too.
Thank you again for your patience and support.