# Report TimeSeries Chart doesn´t plot the values **URL:** \ **Category:** Ignition\ **Created:** [June 27, 2023, 7:49am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565 "2023-06-27T07:49:30Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [June 27, 2023, 7:49am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/1 "2023-06-27T07:49:30Z")
Hello I have a issue, i have make a query from MySQL DB, and return a few value, and a timest, that are the timestamp, a char field, I recive the results from the qyery, BUT no lines in the chart. i can se there is plenty of row to make lines from... is there any issue with the 'timest' field from the DB? ![ChartIssues](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/9/39ea7dd23416fa84183a66782473cac1970d8dd3.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/7/c7f83d75064a5070cc9aa41d2466a84604f0b1c1.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [June 27, 2023, 8:22am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/2 "2023-06-27T08:22:22Z")
Hi, Jonas. I deleted the "Perspective" tag from your question because this is a "Reporting" module problem and that is independent of Perspective. ---
**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:** [June 27, 2023, 1:16pm UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/3 "2023-06-27T13:16:26Z")
No obvious problem. Perhaps the chart's timespan isn't matching the data's timespan? ---
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [June 28, 2023, 9:03am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/4 "2023-06-28T09:03:13Z")
Hello, thanks for the input, but isnot the charts timespan "auto" adjust to the input? ---
**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:** [June 28, 2023, 11:51am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/5 "2023-06-28T11:51:15Z")
Did you manually scale the axes? I can't tell what your flow range is, but none of the values would plot in the 0-140 range shown on the left. ---
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [June 29, 2023, 8:39am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/6 "2023-06-29T08:39:19Z")
I connected the flow, to the right axis, that are 0-10000, and the other to the left axis 0-140, it´s seems like the timespan, is not understand by the chart.. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/3/e3971733eb6276eaf06a8bf7a1b94002c62011a1.png) I try to remove the flow from the query, and assig auto scale to the left axis, Now i atleast got a orange pin in the middle 🙂 ---
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [July 6, 2023, 5:32am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/7 "2023-07-06T05:32:10Z")
Strange thing this, no solution yet.... ---
**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:** [July 6, 2023, 11:20am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/8 "2023-07-06T11:20:25Z")
> [@Jonas\_Klingberg](#): > > seems like the timespan, is not understand by the chart Might be a timezone issue. What timezones are the gateway, DB, and client in this case? ---
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [July 12, 2023, 1:23pm UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/9 "2023-07-12T13:23:40Z")
The timezone on the server is CET+1, Stockholm, I have a report thats run on another site, with the same timesetting on the server. and that report looking fine... this is a screenshot from the both GW is the same formatting, and the project is both using the Gateway time setting. if i run the query manual, i got the result. Very strange I see now, that the GW version on the working side, is 8.1.20, and the faulty is 8.1.23 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/9/49340e407a2fd3e8b6016e4f12d16d848c944897.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e4f444390c71e48857358016384910702c74394.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:** [July 12, 2023, 1:28pm UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/10 "2023-07-12T13:28:16Z")
You might want to get support involved. The cause is not immediately apparent. (Database?) ---
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [July 12, 2023, 1:52pm UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/11 "2023-07-12T13:52:54Z")
Ok, but, if the fault is in the DB, should that be data in the "raw data" windows, when i preview? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/c/fc4f5856855b386d944b3583dde50a8ee309ec15.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:** [July 12, 2023, 1:58pm UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/12 "2023-07-12T13:58:45Z")
> [@Jonas\_Klingberg](#): > > when i preview? I would think so, but I don't know. You might want to get support involved. I cannot explain what you are encountering. ---
**Author:** ![Jonas\_Klingberg](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jonas\_Klingberg](https://forum.inductiveautomation.com/u/Jonas_Klingberg)\ **Post date:** [August 16, 2023, 11:15am UTC](https://forum.inductiveautomation.com/t/report-timeseries-chart-doesn-t-plot-the-values/75565/13 "2023-08-16T11:15:56Z")
Hi.. Small updates on this issue. After research, i see that the Timest filed in the MySQL db, is a char field, and not a DATETIME field, i try to use the str\_to\_Date() function, but no success, I try to export som day from the MySQL db, and import it to a SQL DB, with the DATETIME set on the timest field, and o got plot directly ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/a/1a9415151fa81cf35052b96362f4bf4c30ad81fc.jpeg) SO any ideas why the str\_to\_date not working, im very intresting about 🙂 I have asked the vendor, to se if it´s possible to add a DATETIME filed in the existing DB, and populate it with the timstamp 🙂 i get back...