No datapoints on the graph

1

I am using a simple group by query as below -
SELECT [ESBLOG_NAME] as metric, COUNT(*) as value FROM [MF_DB].[dbo].[ESB_APPLICATIONS]
GROUP BY [ESBLOG_NAME]

When I run the query in the DB, it gives me results however when I run the query from within grafana, nothing shows on the graph. The query inspector although shows rows being fetched back.
I have used TimeSeries as format in the metrics tab, my db is SQLServer.
I have chosen mode as Series and Value as current in the X-axis.

2

you need query a time field to get a time axis as well