AnsweredAssumed Answered

How to find the time at which Max Sum value occured for a given PI tags in a given time frame?

Question asked by GopinathSridara on Oct 19, 2016
Latest reply on Oct 20, 2016 by Roger Palmen

I want to find the time at which Max sum value occurred, excluding the Spike (value greater than 2*Span), Bad data. I want a query to fire to PI database.

Number of tags will be 60 to 100 and time duration is max 1 year and tag name is of 50 characters in length.

 

Tag Name\Time8:008:309:00
Tag1100150125
Tag2spike20050
Tag3200bad data30
Tag4505050
TOTAL350400255

Outcomes