Grafana pie chart with mssql

1

Plot top k items using pie chart plugin using sql server query and format as table

2

you should give a better description.

3

Only works with Time series, ie:

SELECT __timeGroup([data], '60m') as time, motivo as metric, SUM(qtde) AS QTDE FROM [xxx] WHERE [data] BETWEEN __timeFrom() AND __timeTo() GROUP BY __timeGroup([data], ‘60m’), [motivo]
ORDER BY 2 DESC