AnsweredAssumed Answered

Datalink: Getting a list of previous data changes after a tag changes from 0 to 1 for the last 30 days

Question asked by Steven75 on Aug 15, 2017
Latest reply on Aug 16, 2017 by cdekeyser

I'm looking for an expression in Datalink. Unfortunately I can't use Batch so I have to make to following expression in Datalink.

If tag X changes from 0 to 1 then I want to know that timestamp (A) and the timestamp (B) of the event when tag Y changed for the last time from 0 to 1 before timestamp X for the last 30 days.

Events.jpg

In short: When A happens I want to know the timestamp of A and B in 2 separate cells. This must be done within a time period of lets say 30 days so I need all A's and previous B's for the last 30 days each in a new row.

 

Is this possible without using VBA?

Outcomes