How can I set up my graph to take the already created kWh daily power consumption and show that value day over day for the month. So each day the Daily Power Consumtion single stat value gets aggregated to the monthly graph.
I have tried sum() tried few different things and not able to get the correct result.
Below is the screenshot of the graph settings.
To do something like this dashboard.
That has the 30day power consumption.
I copied his dashboard and set my values, and not getting the desired result. I see he is querying the sum() of the value and grouping by day for a month time range. When I do that, I get this result.
My Y Axis is in MegaWhatts, and my Costs are $12,000. Which is not right.