weather-display.com currently has a simple graph in their display with the TED5000 which works fine with my failing TED-5000. I’ve got iotawatt up and running and want to make sure I use the proper query to supply the proper number for WDisplay. They create a 1 min database of current watts. The below query is what I came up with but I am not sure it is the correct way to do it. It gives me current watts. Please advise if there is a better way.
While it should work, I would change the group to ALL as you are defining a single interval with the begin and end parameters. The query will return the average Watts during the most recent 5 second interval that ended on a 5 second boundary. So depending on when you issue the query, the returned result could be up to 4 seconds old.