Does the Query API return averages?

Support
#1

Hey Bob,

If i use this query on 3 of my outputs

http://172.16.101.200/query?select=[time.iso,Solar,Consumption,Grid]&begin=h-1h&end=h&group=m&format=csv&header=yes

It appears to return a minute by minute reading for the preceeding hour (very quickly too - great work on that !)

Is the minute by minute reading - an average of the values for each minute - or just the value closest to the end (or start) of the minute ?

regards

Craig

#2

If units is Wh, it returns the total for the period. All other units returns the average for the period.

#3

Thanks Bob - it is in Watts

regards

Craig

#4

Just to clarify Bob please

If i do the following query every minute from Node-Red to IOTAWATT will this give me a rolling 5 minute average for each of the channels ? It appears to be doing so and thus letting me schedule loads to use excess Solar etc - but just wanted to confirm my understanding was correct ?

http://172.16.101.200/query?select=[Solar,Consumption,Grid]&begin=m-5m&end=m&group=5m&format=json&header=no

Craig

#5

Yes, that will give you a 5 minute average, but on minute boundaries, if that’s what you want. For instance if the query is made at 11:23:02 you will get the average for 11:19;00-11:23:00. If the same query is made at 11:23:59 you will get the same result.

To simply get the average for the last 5 minutes to present, use begin=s-300s&end=s&group=all

1 Like
#6

Good one thanks Bob - thanks for the clarification - for what i am doing in terms of averaging out available solar/excess to enable the running of arbitrary loads then either will work - but as you have shown the option using Seconds will give a more deterministic and reproducible result.

Have a great XMAS

Craig

1 Like