Its first time I am trying to execute sql query in grafana.
My query is quite simple as I am looking for bar chart between number of user login w.rt. to date.
So I have selected dashboard-> graph -> edit and pasted my query ,but its showing error
“Found no column named time”.
I want to see a bar graph (user login w.rt. to date).
Current Login_Time is in format of mm/dd/yyyy so I need to convert this into only date format and create a graph.
I have gone through many links and tried few of them but unsuccessful.
The below 2 solution which is provided on support side:
now() as time_sec – > error mssql: ‘now’ is not a recognized built-in function name.
__timeGroup(“GMT_CREATED”, ‘24h’, 0),-> erro mssql: ‘__timeGroup’ is not a recog
Kindly guide me .