I am tiring to make a simple line graph with some data from MSSQL and I have no idea what I am doing wrong.
My SQL is;
SELECT DATEDIFF(s,‘1970-01-01 00:00:00’,Date) as time, BudgetDaily
FROM
dbo.BudgetHours
If I run that query on the DB I get the following back;
|time|BudgetDaily|
|1557100800|155.6887|
|1559779200|175.5452|
|1562371200|149.1697|
|1565049600|105.6747|
|1567728000|99.60626|
|1570320000|162.1717|
|1572998400|150.8234|
|1575590400|155.6887|
Looks good… But when I run that same query in Grafana I get no data back if the query if the format is time series. However, table series will return data.
Must be something I am not understanding here. Can anyone help me out?
Thanks