Trying to get a dataset to populate in a time series chart. Everytime I try to use a database query I get component error on the chart. Following the documentation I placed my timestamp first and that is datatype DateTime in sql server followed by MetricValue which is just a decimal value. I added the MetricValue column under trends in the props section. Not sure what I am missing any help would be great.
Your timestamps do not appear to be in order. Add an ORDER BY clause to your SQL.
Right-click on the chart in the Project Browser, copy, and paste the code in here. See Wiki - how to post code on this forum.
Do the same with the Perspective Property Editor "series" property as we won't be able to reproduce the dataset and will need your data for testing.
We can then reproduce the problem.