Get a percent of active time

bingbadabom · ‎03-27-2023

I have data that consist of a timestamp (datetime) and a value.

These values come in with about 2-3 minutes a part. Sometimes there's gap in the data. These gaps are often hours long.

If you see the following chart:

I would like to group the clusters of data as "active" and the empty space as "inactive" to be able to calculate some sort of uptime.

Any tips for how i can accomplish this?

Arul · ‎03-27-2023

Would you able to add some sample data?

Thanks,

Arul

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

bingbadabom · ‎03-27-2023

Sure, it looks something like this (unneeded columns removed).

weight time date

Helpful resources