Werum

Query for value with longest time in a time range

Discussion created by Werum on Apr 10, 2014
Latest reply on Apr 30, 2014 by Gregor

HI,

 

I am trying to get the value with the longest duration in a tag for a given time frame.

 

For example:

 

I know the start and end time that i would like to query. I know the tag name. But I need the value within this time frame which has the longest duration in total.

 

I am using PI OLEDB provider.

Outcomes