XY-chart cannot display the value that use to GROUP BY (MySQL)

Grafana MySQL
,
1

v10.4.3

I’m trying to draw a line chart that x-axis represent type of modality and y-axis represent number of times each modality is used.

I have query like this:

image
image812×32 7.36 KB

But I said “No Y value”
The same thing happens when I tried to select axis by manual.

I assumed that this because grafana does not count the “modalityCode” as an collum contain value to plot because of the “GROUP BY” part. Which is work well with bar chart.

image
image1166×248 15.5 KB

I expected that I can represent it in line like this:
image

Please help!!

2

Hi,

XY Chart is only for two numeric fields.

3

Thank you.
So how can I draw a graph like above without using bar chart? I need that to be in line chart

4

That’s a simple task for Business Chart plugin

XY chart
XY chart1915×1025 91.9 KB

1 Like
5

Chart appearance could be customized to your needs:

Business chart
Business chart873×531 19.6 KB

2 Likes
6

There would be another unsightly way into grafana itself.

image

You have to convert the x-axis string values into enum.

image

But I think the right way is via the Business Chart plugin.

2 Likes
7

Thanks for you guys helps

8

Thanks for your answer. That help me a lot, but I have an extra question.
Does this plugin have option to show data when I hover the mouse to the data point like this?
image

9

try

tooltip: {
trigger: ‘axis’
},

or

tooltip: {
trigger: ‘item’
},

1 Like