I can’t get perspective to trend a custom query.
I’m using a time series chart and a named Querie
SELECT DateTime, LeftHeight
WHERE DateTime >‘2020-09-09 14:00’ ORDER BY DateTime DESC
when tested the Named Querie it shows all the values and columns with no issues
If I use a table it shows the data, but the DateTime column shows values instead of Dates
and my Time Series Chart keeps throwing “Componen error”… I’m bindig the named querie as a dataset in the Table Series property
Does anyone have a basic example on how to trend and show data coming from SQL, not historian…?