[SOLVED] Grafana : Show Fridge Power and Door Status on same chart?

TommySharp · November 7, 2018, 9:04am

I’m trying to show a number and contact on the same chart so that I can see the power consumption of my fridge and also when the door was open.

I’m using Grafana and I can see in the InfluxDB that the door contact changes to 1 when open and so it’s purely an issue with the scales… You can actually see the little blip on the chart when the door was opened and closed.

Does anyone know if settings can be applied to the one series to make the open/close status more prominent? Maybe multiplying it by 100? Although I don’t want to have to do this with rules

Dim · November 7, 2018, 9:08am

yup… in theory with math

TommySharp · November 7, 2018, 9:14am

Awesome thanks @Dim I was actually just trying that out as you replied… Didn’t work until I removed the default grouping that Grafana adds…

Dim · November 7, 2018, 9:17am

Display -> Staircase check to look nicer

edit: no… this will affect also the other power consumption series and they look better without staircase

edit2: actually you can use series overrides to apply staircase only to the fridge door status series (leave the default without staircase check mark)

TommySharp · November 7, 2018, 9:21am

Cool, yeah looks a bit better with a series override of staircase now Thanks!

vzorglub · November 7, 2018, 9:38am

You could also have assigned the door to the other Y axis (On the right) and that would have scaled automatically.

TommySharp · November 7, 2018, 10:30am

Good idea! How do we assign it to the other Y axis?

vzorglub · November 7, 2018, 10:33am

Enable Right Y axes:

Override display of series to Y-axis: 2

Result:

TommySharp · November 7, 2018, 11:58am

Awesome thanks!