What Grafana version and what operating system are you using? Grafana 8.1.2 and InfluxDB as datasource What are you trying to achieve? [Screenshot 2021-11-12 at 11.32.04] I’m trying to replicate this dashboard into Grafana. I have already access to the values like daily_energy_vt and daily_e…

I have found a way using Flux that does not take into account my issue from(bucket: "homeassistant/autogen") |> range(start: v.timeRangeStart) |> filter(fn: (r) => r._measurement == "kWh" and r._field == "value") |> filter(fn: (r) => r.entity_id == "daily_energy_nt") |> aggregateWindow(ever…

Can you share the queries that you have tried thus far and the results they have produced?

[Screenshot 2021-11-12 at 12.44.10] here it is.

I see you are using Time Series. In the upper right, what happens when you change to Histogram? [image] Please change and then post the same screenshot.

[Screenshot 2021-11-12 at 13.02.34] problem is that histogram in x axis does not have the time

OK, so obviously Histogram is not the right visualization tool here because you want aggregate (sum of the energy values) on an hourly basis, but still want to use the Grafana dropdown (6 hours, 1 week, etc.) to change the time scale, correct? Am pretty sure this is possible, but will take some exp…

I’ve tried but nothing. it did not work. I’m pretty sure that this is not directly possible in Grafana w/o before making a transformation on those data.

Like I said, you will probably have to write the query directly in the query editor (not using Grafana’s query builder) to get what you want. This post might be a good jumping off point.

I’ve also enabled fluxql so it should be now easier. I will play a bit and see if I can get to the solution and then I’ll post it back. I’m new to fluxql so no idea atm how to write that query.

Unfortunately I couldn’t use Flux. it’s very buggy and indeed I cannot use it properly. The issue is even tracked here but no much interest to fix Error: panic: runtime error: invalid memory address or nil pointer dereference · Issue #21649 · influxdata/influxdb · GitHub So I have to use the Influx…

Display data as histogram collected by buckets for time

Grafana Graph (Old) Panel

grant2 November 12, 2021, 4:24pm 11

Maybe this solution? Calculate difference between two measurements - #7 by aleksas

Topic		Replies	Views
Bar Chart Panel showing the energy consumption in intervals of 6 hours Bar Chart Panel influxdb , query-help	1	790	June 4, 2024
Grafana influx2 flux query group by time InfluxDB	1	4331	August 30, 2022
Get graph on energy Time Series Panel	0	564	November 25, 2018
Dashboard Math Problems InfluxDB	19	1179	September 15, 2023
Help graphing energy data Grafana value-mapping , transformations	2	1369	February 16, 2022

Display data as histogram collected by buckets for time

Related topics