Hi, I would like to draw a bar chart based on the data available in mysql data base. I am using the mysql data source plug in with Table option to draw chart. I am getting below exception after writing “No field name specified to use for x-axis, check your axes settings” When i try to add filed n…

For the graph you should use Time series mode and specify time_sec, value and metric fields. Look at this example: SELECT clock AS time_sec, value, itemid AS metric FROM history where itemid=23295 AND clock > UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 6 HOUR)) AND clock < UNIX_TIMESTAMP(NOW()) OR…

I want to draw a normal histogram chart where x axis would be status like string values “Accepted”, “Rejected” comes from group by query. My requirement is not time series, it’s just static data which refreshes may be for every 5 min. Is it possible to draw graph with this information?

Hi, same issue here. MySql datasource and I’d like to draw a non time series hystogram chart. Is that currently possible? Any hint/example on how to do that? @madhup have you find a solution to this? Thanks.

Draw line/bar graph with mysql non time series data

Grafana

snkhan December 25, 2017, 7:27pm 5

Plotting of non-time series data is not currently supported according to Use graph with mysql and non time metrics, however, I too would love to be able to plot non time data.

Topic		Replies	Views
Use graph with mysql and non time metrics	13	17887	September 28, 2018
Bar chart with non time series data from MySQL MySQL mysql , bar-chart	3	2327	December 6, 2023
Graphs for non -time series data Grafana	1	5562	February 19, 2018
Create bar graph with mysql datasource MySQL mysql	2	2632	September 7, 2020
Form Graphs from a MySQL Tables; mysql	8	12489	February 20, 2018

Draw line/bar graph with mysql non time series data

Related topics