Stacking MySQL values in a Bar graph

Grafana Time Series Panel
1

Hi there,
I would like to read out a value from a MySQL database, group it according to a day and display it as a bar graph.

SELECT
DATE_FORMAT(DATETIME, “%d.%m.%Y”) AS “Datum” ,
(MAX(wert) - MIN(wert))/100000 AS Heizung
FROM input
WHERE art = ‘Heizung_WATT_Gesamt’
GROUP BY Datum

grafik
grafik1208×888 68.2 KB

It should look like this:
grafik

I have several of these queries that I now want to display in a bar graph, one above the other.
I don’t get the graphic to show different layers though. Best of all in different colors.
Can you give me a tip how I can do that?
Thank you very much
Christian

2

Hi,

I see that you are using queries with different units (Axis), i suggest you have a look at this thread :

Hope it helps.

Good Luck

3

No, The MySQL code works fine. But iam not able to stack the result in den grafic.