I have a query that calculates energy used per day.
SELECT DERIVATIVE(last("value"), 1d) as usage FROM "home_assistant"."autogen"."kWh" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "entity_id"='consumption_low_tarif_sensor' GROUP BY time(1d) FILL(none)
I get different results for the table view and the bars view:
I expected two bars (one for each day) with these values but i only get one bar for the last day.
Am i doing something wrong? Anything i should add to the query?
I’ve tried a similar query and it works as expected, in both visuals… but I found the problem
The Query:
SELECT DERIVATIVE(Last("Percent_User_Time")) AS "Derivate of last CPU %" ,last("Percent_User_Time") AS "Last CPU %" FROM "windows_system_monitor"."autogen"."win_cpu" WHERE time > :dashboardTime: AND time < :upperDashboardTime: GROUP BY time(1d) FILL(null)
First example:
Date Picker From 2019-12-09 00:00 to 2020-01-02 10:11
which gives me this result:
time | win_cpu.Derivate of last CPU % | win_cpu.Last CPU %
------------------------------------------------------------
2019-12-09T00:00:00.000Z | | 6.228960514
2019-12-10T00:00:00.000Z | 10.80228376 | 17.03124428
2019-12-11T00:00:00.000Z | -12.4821806 | 4.549063683
2019-12-12T00:00:00.000Z | -2.20650363 | 2.342560053
2019-12-13T00:00:00.000Z | -1.575127363 | 0.76743269
2019-12-14T00:00:00.000Z | |
2019-12-15T00:00:00.000Z | |
2019-12-16T00:00:00.000Z | 0.046413362 | 0.906672776
2019-12-17T00:00:00.000Z | -0.906672776 | 0
2019-12-18T00:00:00.000Z | 1.265742183 | 1.265742183
2019-12-19T00:00:00.000Z | 41.46238816 | 42.72813034
2019-12-20T00:00:00.000Z | -11.9473877 | 30.78074265
In the chart, the first value is visible: (mean = 6.228960514)
Second example:
Date Picker From 2019-12-09 10:00 to 2020-01-02 10:11
Note that the range starts 10min later
The table returns the same values (but keep in mind that values of the first ten minutes won’t be considered, which is not a problem in this case since the last value is not in that range)
In the chart, the first value is plotted but is somehow hidden: (mean = 6.228960514)
I’m not sure if this is a bug or if it’s working as intended, for the moment ensure that the range starts exactly from “00:00”… (maybe the Influx guys cant tell us something about that @rawkode)
Hope this explains your issue.
