Pie chart config issue

Grafana Configuration
1

image_2021-09-29_140710
image_2021-09-29_1407103840×1922 267 KB

Hi everyone,
Could you please help me create pie chart graph which shows a percentage of number appears in a single column i.e number 5 is 30%, number 4 is 20%…
Thank you so much in advance.

Thanks,
Dat

2

anyone can help me pls

3

What is the data source you are using?

4

Hi Lochanie,

Thanks for your feedback. I’m using MySQL data source

5

write group by query for each number in edit sql field.

select $__timeFilter(Time) as time, sum(DataPointNCProgram…) as total
from your table name
where DataPointNCProgram… =5 and Time=(time range you want to get the total)
Group by $__timeFilter(Time), DataPointNCProgram…

Please edit the query according to your requirement. Then write a similar query in next frame. you can open the next frame by clicking +Query button.

Then select piechart and select the field=name what you given in the query “as total”. the select the labels=percentage.

1 Like
6

Hi Lochanie,
I did it. Can’t thank enough for your help.

Thanks,
Dat

7

Hi Dat,
happy to hear that.

Regards,
Lochanie

8

Hi Lochanie,
Could you please help me how to set the offiline signal on the Grafana when the MySQL stop sending the signal. Because the Grafana still keeping last signal of MySQL and when the people look into the dashboard, they though it still online.
Attached you can find the dashboard still update the last signal from MySQL.
Thank you so much.

Capture
Capture1920×940 46.3 KB

9

Hi datanguyen,

Actually I didin’t get your question? could you please explain more? could you please publish the query?? if there is any possibility?

10

Hi Lochanie,
The problem solved. I have been tried by another way, sorry to made you confuse.
Thank you so much.