ygalipeau

returning average values

Discussion created by ygalipeau on Jan 11, 2012
Latest reply on Jan 12, 2012 by kilgored

good evening,

 

i am using the pi oledb console for testing some pioledb queries. the following query works

 

select count(value) from piarchive..piinterp2 where tag = 'sinusoid' and time >= 't' and time < '*' and timestep = '10m'

 

but if i am changing the count for max or avg i have an error saying: Overload Resolution Failed for (max) argument(s).

 

 

 

is there a way to get the average or max of the values? i don't want to bring back all the data in a table and do the average or max on the records, but retreive directly the aggregates from the SQL query. also, i need to force a value each 10 minutes, so i cannot use the piavg or pimax table

 

thanks

 

yannick

 

 

Outcomes