Ms SQL Data to TimeSeries

Hi Everyone.

Please Assist: I have data coming to Grafana from Ms. Sql as a Data source.
I’m struggling to change the data to time series: If I change table to time-series it says “Data is missing a number field”

Here is the Query :
SELECT
$__timeEpoch(timestamp),
Variable_Value AS Value,
Variable_name AS Metric
FROM Keystardb.dbo.Grafana
WHERE
$__timeFilter(timestamp)
ORDER BY
timestamp DESC

Can you inspect the query with the query inspector? Perhaps your Variable_Value value is a string and not a number?

2 Likes