# Time series chart from a dataset tag **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [March 31, 2024, 3:47am UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117 "2024-03-31T03:47:39Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Post date:** [March 31, 2024, 3:47am UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117/1 "2024-03-31T03:47:39Z")
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 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/3/03c0c355427e2f79af06b4fa94c11f9ec0aac598.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/3/d34f36831f191cc495580db3b0a0d49fa18a5c3b.png) I have also mapped the RRP column to the trend. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/9/09919cc1f0b2583fd2226af698e0233cc966b06d.png) Not sure what could be the issue. ---
**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Post date:** [March 31, 2024, 4:58am UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117/2 "2024-03-31T04:58:08Z")
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. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/8/38a7c3f5c895aaaa741143fd4aed550c4a3ac195.png) > [@Unable to apply SQL query binding to Chart, Bar Chart and Easy Chart](https://forum.inductiveautomation.com/t/unable-to-apply-sql-query-binding-to-chart-bar-chart-and-easy-chart/15422/2): > > 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. ---
**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Post date:** [March 31, 2024, 5:03am UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117/3 "2024-03-31T05:03:40Z")
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. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/4/e4298e93a83fa4e906ba21ad57f01dcca8984826.png) ---
**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Post date:** [March 31, 2024, 5:05am UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117/4 "2024-03-31T05:05:15Z")
XY chart works great, but I want to have a x trace to track the values. XY chart does not support this function. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/3/c38484c1cebb1a9819c4fa01c3ecc60179ebc59a.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 31, 2024, 12:41pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117/5 "2024-03-31T12:41:10Z")
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? ---
**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Post date:** [March 31, 2024, 1:09pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-from-a-dataset-tag/88117/6 "2024-03-31T13:09:52Z")
You are legend. Never thought about that.