Hi folks, I have got a result like this.
|time|value|metric|
|1555452458|201|WOMAN|
|1555452458|501|NULL|
|1555452458|1958|MAN|
ı tried many things but i couldn’t make it.
SELECT
count(*) as value,
Gender as metric
FROM
[dbo].[BI_people]
GROUP BY Gender
how can i able to use this query as a pie chart. i am getting an error when i changed to table to time-series
Many thanks. i know a lot of people asked before most of them on mysql. i can execute my tsql query succesfully but grafana throw an error metric type: NVARCHAR but datatype is .
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?