Good morning, I am trying to put a query in the data of a Time series chart but I always get an error, I think the data is ok, the time is in date and the tag value in double, the data is sorted, I don't know what could be wrong.
Could you show how you are binding the data to the Time Series chart?
Without seeing that, it looks like the data is configured correctly according to the last point in this tooltip for the data property of the series list items.
Make sure that when you are binding to the series you keep the structure the same: a list of dictionaries that have a name and data key where data would be the dataset from your query.
Hello, thank you for your prompt reply.
here is the binding, it is a query to a database, there is no column with a key
Take a look at this topic. Could possibly be an issue with the timestamp coming in as datetime2 type. I have not read through the whole thing, but it may work if you were able to convert the timestamp to a datetime
That is a very old post, and it's for the Vision Easy Chart, not the Perspective Time series chart.
There should not be any issue with the datetime2 column data type and I would not recommend converting to datetime.
@Diego_Mejia try changing your query to look like this:
SELECT TOP 100 t_stamp as 'time',Tag1,Tag2
FROM test5
ORDER BY t_stamp
Then change your Return Format to JSON.
Hi, sorry for the late reply, you're right hahahah the column should be called 'time'.