Alarm Log Page

Hi foodd , BeaBF , Anonymous,

Please accept my sincere apology for not providing necessary/insufficent information.

Please refer to the attached files and work is in progress for the same.

Question:

Lets consider a alarm of Low Temperature triggered at 11:01 and the it was active till 11:30 so between 11:01 to 11:30 Alarm Category will be Low Temperature. So here I want first row in the alarm log table that should be 11:01 as a start time instead of all records between 11:01 to 11:30.

For Sample I am Creating a dummy Alarm Log Table to get visualize how alarm log table should look like.

Please refer to the attached files of Sample Data set and pbi

Sample Data:

https://docs.google.com/spreadsheets/d/1675VjlLLT-3r_gx8JJY7be3KVX3hCFXl/edit?usp=sharing&ouid=110720534063898360565&rtpof=true&sd=true

pbi File:

https://drive.google.com/file/d/1tDY0ajaXCRlxt4LIzIL19HbV0RnxUg4S/view?usp=sharing