I have a query
SELECT timestamp(t_stamp) as 'Time', COUNT(Distinct Total_Good_Count) as Count
FROM mes.group_table_d01
GROUP BY HOUR(t_stamp), Date(t_stamp)
ORDER BY date(t_stamp), Hour(t_stamp);
That returns data like so
2019-09-09 14:00:00, 759
2019-09-09 15:00:00, 708
2019-09-09 16:00:00, 210
2019-09-09 17:00:00, 720
2019-09-09 18:00:00, 693
2019-09-09 19:00:00, 760
2019-09-09 20:00:00, 624
2019-09-09 21:00:00, 745
2019-09-09 22:00:00, 469
2019-09-09 23:00:00, 771
2019-09-10 00:00:00, 771
2019-09-10 01:15:39, 625
2019-09-10 02:00:00, 620
2019-09-10 03:00:00, 391
2019-09-10 04:00:00, 504
2019-09-10 05:00:00, 672
2019-09-10 06:00:00, 681
2019-09-10 07:00:00, 460
2019-09-10 08:00:00, 690
2019-09-10 09:00:00, 522
2019-09-10 10:00:00, 560
I have been trying to figure out how to bind this to the Time Series Chart. Perspective Componet. When I bind to the data property. Under Series property. Using return format of JSON from named query like so.
It errors the component out.
this is how it’s set up from example.
What am I missing?