The time series chart works fine when query from database, but when I tried to try using a dataset tag, it didn't display the trend.
here's the dataset tag.
the t_stamp column is Date type and RRP is double type
I have also mapped the RRP column to the trend.
Not sure what could be the issue.
by referring to the following suggestions, I have swapped the column order, made the time column to be the first column, but still not working.
You can’t put your own SQL into an EasyChart. The Classic Chart (for time series) needs each dataset to have either a datetime, timestamp, or long integer (milliseconds) column as the first column, with all other columns interpreted as pen data.
the data type of the time in the dataset tag is "timestamp".
I tried to change it to unix integer as ms, it didn't work either.
XY chart works great, but I want to have a x trace to track the values. XY chart does not support this function.
Putting the time column first is specified in the documentation. With that, what you are showing looks right. Perhaps not doing so first screwed up the component. Have you tried deleting it and starting over?
You are legend.
Never thought about that.
1 Like