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