AnsweredAssumed Answered

How to totalize a tag with conversion factor

Question asked by jmgilman on Nov 2, 2015
Latest reply on Nov 3, 2015 by stang



I'm trying to write a PI ODBC query for totalizing a flow rate tag over a 24 hour period. I'm having issues finding where I can apply a conversion factor for the tag in the query (I need to use 1440 since the flow rate is in GPM). Here is my vanilla query:


SELECT time, value

FROM piarchive..pitotal WHERE tag = 'blah'

AND time BETWEEN '10/29/2015 12:00 AM' AND '10/30/2015 12:00 AM'


How would I incorporate the conversion factor into that query?