[SOLVED] Cannot get Perspective TimeSeriesChart to accept data from a SQL query

[bmeyers]

I have two TimeSeriesCharts; the default chart with default data and then a second TimeSeriesChart with a single binding to replace the data. In the picture you can see my named query is bringing in a time and average column from a database. I am returning the data in json format and it looks like it should work ok.

However, the component states “Component Error”. Does anyone know why my binding doesn’t work with this component?

[bmeyers]

Solved my problem. There were 2 issues.

1. You have to select the first column as ‘time’. Capitalization also matters.

2. You have to order the data by time. It fails if the timestamps are out of order but won’t tell you why.