Latest version of the data source installed, everything works as expected, apart from being unable to get the dates to work. I have copied the sample SQL query provided in the documentation, but even that returns "Invalid date" on the graph and the X axis is not drawing data properly. Here is the query used:
DECLARE @data TABLE(value decimal, dt DateTime);
DECLARE @stopDT DateTime = '$to';
DECLARE @startDT DateTime = '$from';
WHILE(@startDT < @stopDT)
BEGIN
INSERT INTO @data VALUES(RAND(),@startDT);
SET @startDT = DATEADD(minute, 1, @startDT)
END
select 'metric' as metric, * from @data
This is used as timeseries, here is the JSON response i get:
figured out the issue - the sample query provided in the documentation had metric selected first, while you actually need time, value, metric - in that precise order.
Latest version of the data source installed, everything works as expected, apart from being unable to get the dates to work. I have copied the sample SQL query provided in the documentation, but even that returns "Invalid date" on the graph and the X axis is not drawing data properly. Here is the query used:
This is used as timeseries, here is the JSON response i get:
I noticed that I don't get a date in the response, is this normal?
Here is a screenshot of my graph: https://i.imgur.com/4n5NSjo.png