Nikolas Koesling NikolasK-source

NikolasK-source / vz.md

Last active June 1, 2020 19:22 — forked from adlerweb/vz.md

Grafana MySQL query to visualize Volkszähler-Data

Using Channel-IDs (that's not UUID)

SELECT
  timestamp * 0.001 as time_sec, 
  data.value as value, 
  properties.value as metric
FROM data
  LEFT JOIN properties ON (properties.entity_id = data.channel_id)
  LEFT JOIN entities ON (entities.id = data.channel_id)