I have the following query for a single stat panel, which show the total consumed power the last day:
SELECT last(“value”) FROM “W” WHERE (“entity_id” = ‘power_usage_overall’) AND $timeFilter
GROUP BY time($__interval) fill(null)
In vizualization I have set the value display to total which shows the right result.
Now I would like to achieve the same for the last 7 days with the graph plugin, in order to get these values I use this query:
SELECT sum(“value”) FROM “W” WHERE (“entity_id” = ‘power_usage_overall’) AND $timeFilter
GROUP BY time(1d) fill(null)
In combination with the relative time option set to 7 days.
The issue: The Graph shows way to much in terms of power.
See attached screenshots:
What I’m doing wrong on here?