# TimeSeries Chart **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [February 10, 2020, 2:16pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095 "2020-02-10T14:16:44Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![etlikmilos](https://avatars.discourse-cdn.com/v4/letter/e/fbc32d/32.png) [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Post date:** [February 10, 2020, 2:16pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/1 "2020-02-10T14:16:44Z")
Hi, all I have a problem when I use Time Series Chart. If I use this Query : SELECT top 3000 Fim09\_ProcesBAc.F09\_Machine\_Mould\_Press\_AmountOfInject\_TIMESTAMP AS time, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Press\_AmountOfInject\_VALUE AS Dávka, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Press\_PressMould\_VALUE AS Tlak\_formy, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempDownCenter\_VALUE AS Teplota\_spodek\_střed, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempDownSide\_VALUE AS Teplota\_spodek\_strana, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempUpCenter\_VALUE AS Tepota\_vršek\_střed, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempUpSide\_VALUE AS Teplota\_vrch\_střed, Fim09\_ProcesBAc.F09\_Machine\_Times\_CycleTime\_VALUE AS Čas\_cyklu FROM Fim09\_ProcesBAc GROUP BY Fim09\_ProcesBAc.F09\_Machine\_Mould\_Press\_AmountOfInject\_TIMESTAMP, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Press\_AmountOfInject\_VALUE, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Press\_PressMould\_VALUE, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempDownCenter\_VALUE, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempDownSide\_VALUE, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempUpCenter\_VALUE, Fim09\_ProcesBAc.F09\_Machine\_Mould\_Temp\_TempUpSide\_VALUE, Fim09\_ProcesBAc.F09\_Machine\_Times\_CycleTime\_VALUE ORDER BY time asc then my component doesn’t work. But when I change the last line on ORDER BY time asc component work but I don’t have sorting. ---
**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:** [February 10, 2020, 3:35pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/2 "2020-02-10T15:35:27Z")
You have a GROUP BY clause but no aggregate operations in your select list. Try removing the GROUP BY clause. ---
**Author:** ![etlikmilos](https://avatars.discourse-cdn.com/v4/letter/e/fbc32d/32.png) [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Post date:** [February 10, 2020, 9:00pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/3 "2020-02-10T21:00:07Z")
Hello thank you i removed GROUP BY and the component is function but when i want sorting with DESC,the component not show me data. It is empty and Ignition designer have alarm on this component. ![alarm](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a0d23a646e9cf70ecf2ac6f1b5937a1545c39866.png) ![setting](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/09384fecbe9357ee2e6f0038b5fad803eacaa798.png) ![sql](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/63ac124f7adf47c8db4157485bd0a78b56409eb5.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:** [February 10, 2020, 9:02pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/4 "2020-02-10T21:02:56Z")
Try running the query in the query browser so you can see any error reports. ---
**Author:** ![etlikmilos](https://avatars.discourse-cdn.com/v4/letter/e/fbc32d/32.png) [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Post date:** [February 10, 2020, 9:23pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/5 "2020-02-10T21:23:15Z")
it is look ok ![browser](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/de4eddc618ef214ba278ca3dec2cebb698258380.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:** [February 10, 2020, 9:33pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/6 "2020-02-10T21:33:46Z")
That screenshot shows identical `time` values throughout. I don’t know how ordering by time is impacting either query. ---
**Author:** ![etlikmilos](https://avatars.discourse-cdn.com/v4/letter/e/fbc32d/32.png) [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Post date:** [February 10, 2020, 9:55pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/7 "2020-02-10T21:55:12Z")
Yes it is but when set sorting ASC everything function normal and graph is ok but when i set sorting DESC my graph is empty. ---
**Author:** ![etlikmilos](https://avatars.discourse-cdn.com/v4/letter/e/fbc32d/32.png) [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Post date:** [February 10, 2020, 10:05pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/8 "2020-02-10T22:05:47Z")
So I tried to create new table SQL and new easy questions to Query . How you can look with DESC I have graph empty and with ASC is ok. I don’t understand that ☹ ![asc](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a743a9b72034da718efb09d0830042c24632762d.png) ![desc](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/faf9b6923c9434fef0fe1745227b394850f2c414.png) ---
**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\ **Post date:** [February 10, 2020, 11:52pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/9 "2020-02-10T23:52:52Z")
This is how all mine look like: ```auto SELECT timestamp(t_stamp) as 'time', COUNT(Distinct Total_Good_Count) -1 as Count FROM {grouptbl} GROUP BY HOUR(t_stamp), Date(t_stamp) ORDER BY date(t_stamp), Hour(t_stamp); ``` ---
**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:** [February 11, 2020, 12:08pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart/32095/10 "2020-02-11T12:08:54Z")
Are we sure Perspective’s Time Series Chart can display in reverse order at all?