Pie Chart Not working

[megah]

I am trying to get an MSSQL query to display as a pie chart. When I run the query in a standard query editor it returns a Platform code and it’s corresponding record count for the previous 24 hours.

When I attempt this within Grafana I see a “this.datapoints is undefined” appear in the top right.

Any ideas? Below is the SQL query that works in a query editor

SELECT Platform, COUNT(Platform) AS Total
FROM dbo.CustomerCallData
WHERE CallRecordType=‘Technical’ AND CallDateTime < GetDate() AND CallDateTime > dateadd(hour, -24, GetDate())
GROUP BY Platform

[mrobles]

You don’t have the correct format.
Check this post

MSSQL Server query to piechart

In this article, https://grafana.com/docs/features/datasources/mssql/, it looks like the metric is in the database with NVARCHAR(# of characters). The (.) or period/point error looks to be saying that no NVARCHAR is defined. Is the NVARCHAR value defined in your db for Gender?