I have been enjoyed one of the best program so far and playing with it since I was able to connect to MySQL. How do I graph the total Watts from Watts1 and Watts 2. This is my query that I have so far.
SELECT
UNIX_TIMESTAMP(datecreated) as time_sec,
devicevalue as value,
devicename as metric
FROM history
WHERE $__timeFilter(datecreated) and deviceroom = ‘Energy Monitor’ and devicename in (‘Watts 1’, ‘Watts 2’)
ORDER BY datecreated ASC
Thanks,
Aldo