What type of visualisation can be used in Grafana to achieve the following?

Grafana InfluxDB
1

  • What Grafana version and what operating system are you using?
    Grafana in Docker version Grafana v11.3.0 (d9455ff7db)
    InfluxDB InfluxDB v2.7.10

  • What are you trying to achieve?
    Basically I want to show what I would call a heatmap, but instead of the number of occurrences (buckets you call it I think?) I would like to show the values:

image
image1418×726 90.2 KB

The image above shows the 15 min average power consumption (so called power peaks).
I want this to be visualised in Grafana.

  • How are you trying to achieve it?
    Well, my initial thought was to grab the query which already makes a bar graph, add it to the heat map and then try to change the axis or the fact it is counted to something like “value based”. But that’s where I am stuck.

  • What happened?
    I am able to get 2 kinds of Heat maps, one looks like a real heatmap but shows the counts instead of values and the other one shows like one bar of orange gradients and I am unable to explain it.

This one is the heatmap, and it has the setting below calculate set to yes.

image
image2151×1752 294 KB

image
image230×125 3.23 KB

This one is the “orange bar” and has calculate set to no:

image
image2141×1339 306 KB

  • What did you expect to happen?

image
image1418×726 90.2 KB

  • Can you copy/paste the configuration(s) that you are having problems with?
    The query in case:
  from(bucket: "EnergyFlow")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "energy")
  |> filter(fn: (r) => r["_field"] == "Total_W")
  |> aggregateWindow(every: v.windowPeriod, fn: mean)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    N/A

  • Did you follow any online instructions? If so, what is the URL?
    Not specifically, I found a topic that had a similar question (I think) but the user that posted the question never followed through or posted his solution.

2

I think you could try looking into State Timeline visualization. I remember there was some post that tried to achieve that with State Timeline so you could look for it (unfortunately, I don’t remember anything more :sweat_smile:) if it won’t work out of the box. I guess you’ll need a different series for every day (not using influx, so I don’t know how to achieve that too, sorry :smile:).

3

Hmmm, good point, you got me thinking/experimenting.
How (what mechanism) functionality could make this visualize/group it by days for example?

I can show it for a day now, but I would now need to repeat this for each day of the month. If i include more days in the timeframe Grafana comes back with a message saying the datapoints are too many.

image
image2330×927 176 KB

By the way, I also noticed that when using State Timeline you need to implement a color tresholds yourself, which makes it not dynamic based on the values. I am not sure we are on the right way.

4

I am just freewheeling here, but isn’t there any mapping/map function that we can do which takes all the measurements and returns a serie of measurements per day?

I am maybe using the wrong wording here, I must confess the Influx internal naming of series, measurements, fields, values is very complex to me.

5

Unfortunately, I don’t know much of Influx (none to be more precise). There’s also Business Charts plugin based on Apache E-charts - maybe there you’d find some visualization (you can manipulate data in JS, so it might not be as limited). Anyway, I’d wait for someone other to answer before going into that, since it might be a bit complicated and maybe there is another way.