I am using MSSQL as my datasource, I am trying to count the number of Situations created for each day. Similar to below (Output of my SQL query.), a plot for each day in my graph.
i have a similar query for hourly graph and it is working.
__timeGroup(created_at, '1h', 0) AS time, count(SituationNo) as SIGcount, count(incident) as INCcount FROM report GROUP BY __timeGroup(created_at, ‘1h’, 0)
ORDER BY 1
But when i use the same query and change ‘h’ to ‘d’, i get an error - error parsing interval ‘2d’.
Please help me with this issue.