Bar chart with non time series data from MySQL

phil915 · November 25, 2021, 11:06am

Hey guys,
i am pretty new to Grafana and struggeling to get a bar chart working.

I made this MySQL Query which i want to display with grafana.

How do i “transform” this SQL Query into the Grafana Query Builder to get a bar chart? Is this even possible?

I am using Grafana v8.2.5

Should look alike this:

mattabrams · November 30, 2021, 5:27am

welcome to the forum, @phil915

this should be possible

Have you successfully configured the MySQL datasource plugin and connected to your DB server?

phil915 · November 30, 2021, 6:42am

I got it working now

qbmiller · December 6, 2023, 10:26am

configure the x as the field you want

Topic		Replies	Views
Draw line/bar graph with mysql non time series data Grafana	4	8762	December 25, 2017
Use graph with mysql and non time metrics	14	17674	January 13, 2021
Stacked bar chart using data from mysql MySQL mysql	0	1238	February 26, 2019
Display Non time-series graph Time Series Panel mysql	2	1395	February 24, 2021
How to get Grafana to show query result in stacked bar chart Time Series Panel mysql	0	1799	December 3, 2019