ivstefn

Draw graphs in Grafana using sql from Mango mysql

SQL za iscrtavanje grafova iz Mangovih MySQL stuktura.

SELECT
  $__unixEpochGroupAlias(pointValues.ts / 1000, $__interval),
  dataPoints.name AS metric,
  AVG(pointValues.pointValue) AS value
FROM pointValues
JOIN dataPoints ON dataPoints.id = pointValues.dataPointId
WHERE
  $__unixEpochFilter(pointValues.ts / 1000)
  AND pointValues.dataPointId IN (136, 137, 138)
GROUP BY 1, dataPoints.name
ORDER BY 1