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
WHERE CallRecordType=‘Technical’ AND CallDateTime < GetDate() AND CallDateTime > dateadd(hour, -24, GetDate())
GROUP BY Platform