I have more than one select from diferent mysql tables, to combine in one grafana table. Here is the “selects” that i want to show:
SELECT
$__timeGroupAlias(data_hora,$__interval),
max(horimetro) AS "horimetro",
max(sobcarga_h) AS "sobcarga_h",
max(ocioso_h) AS "ocioso_h",
max(engaiolamento) AS "engaiolamento"
FROM operacao_br
WHERE
$__timeFilter(data_hora) AND
br_id = 1
GROUP BY date(data_hora)
ORDER BY $__timeGroup(time,$__interval)
and the other select:
SELECT
$__timeGroupAlias(data_hora,$__interval),
avg(corrente_a) AS "corrente_a"
FROM operacao_br
WHERE
$__timeFilter(data_hora) AND
corrente_a > 10 and
br_id = 1
GROUP BY date(data_hora)
ORDER BY $__timeGroup(time,$__interval)
But when i put the conditional “> 10” then i have this result:
How can I show these values on a line, since they are daily values?