get the previous values (Not only the last value) which are all matching to the current value for a specific timestamp to calculate machine up time.

Hi,

I need to calculate a machine up time based on the input tag.

Detailed explanation below.

Value Timestamp

100 10/10/2023 12:05:00 AM

100 10/10/2023 1:05:00 AM

200 10/10/2023 2:05:00 AM

200 10/10/2023 3:05:00 AM

200 10/10/2023 4:05:00 AM

100 10/10/2023 12:56:43 PM

I need to check all the previous value when input triggered and get the starting timestamp of that corresponding value (EX: when I receive 200 at 4:05:00 AM as per the data above, I need to get machine up time as 2:05:00 to 4:05:00 AM) and the value difference should be as downtime. (timedifference between 100 and 200 as per the example above). I am trying to use different method to get them in an analysis expression, but unable to find the best way.

Thanks,

Pradeep