Hi, and welcome. It's kinda hard to model to a precision of one hour in with only 3 seconds of data in transactiondate and no idea of the threshold for an outage based on value.
Could you please repost a reproducible example, called a reprex with some clarification? Thanks.
We all want to help, but sometimes a question can't be answered in the abstract.