pihole-influxdb-monitor icon indicating copy to clipboard operation
pihole-influxdb-monitor copied to clipboard

Published 20 hours ago • verified publisher icon avojak

Grafana pi-hole query data = null

Open golvellius opened this issue 1 year ago • 4 comments

Hi .. I would like to thanks you about this great pihole monitor docker. I have been using for 1 week and all is working, but i have a small problem, on query data i have always null value .. image

This is my pihole versions: Docker:2024.01.0 Pi-Hole:5.17.3 FTL:5.24 WebInter:5.21.

Thanks.

golvellius avatar Feb 05 '24 11:02 golvellius

Are there any errors in the logs? And could you try running with the environment variable DEBUG=true and providing a small sample of the log output? It should log out the data retrieved from the Pi-hole before sending to InfluxDB - that'll help me narrow things down a bit. I'm not currently able to reproduce the issue with my setup.

avojak avatar Feb 11 '24 17:02 avojak

image Not sure if this helps, but this is the data shape

Jh123x avatar Mar 09 '24 06:03 Jh123x

image

Seems like changing the transform for the dashboard to this solves the issue

Previously it was max. The data is of type string which seemed to resolve to null when transforming using max

Jh123x avatar Mar 09 '24 06:03 Jh123x

@Jh123x Thanks for the data! I'll need to check out the code more closely, but I wonder if I'm not properly ensuring that the data is sent as the right type...

avojak avatar Mar 28 '24 02:03 avojak