Pie chart doesn't seem to work fine


I’m using latest grafana version and mysql as datasource. the problem is when I’m using graph panel, the graph shows correct results but when I’m using graph’s query on pie chart, it shows weird results.

this is the graph:

and this is the pie chart:


and this is the query I used:

this query is identical for both graph and pie chart. the numbers in graph aren’t even near to the numbers in pie. does anybody knows whats wrong?

what stat are you showing in the pie chart ? (avg, current, total) , this is an option in the pie chart, as your query returns many data points, only one can be used for the pie chart

1 Like