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?