Very novice scripter here trying to create a line graph of counts of a specific value in a column from MSSQL in Grafana.
I presume there is an “A” on the x-axis because I need to declare something in the code and I am sure it is simple. What am I missing? Any help is greatly appreciated.
Visualization is Graph
Format as Table (since the time macros confuse me)
date is column name where the date is stored. Trying to count how many “completed” values per day (date) in the status column.
SQL Query is:
SELECT $__timeGroup(date, '1d') as time, [date], count (*) FROM [servDep].[dbo].[servDep] Where [Status] = 'completed' AND [date] >= DATEADD(day,-30, GETDATE()) Group by date