Time Series Chart. Binding to Data Property

perspective
ignition80
database
namedqueries
#1

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.

post1

It errors the component out.

this is how it’s set up from example.

post2

What am I missing?

0 Likes

#2

Changed ‘Time’ to ‘time’.

TIME has to be lower-cased.

1 Like

#3

@wking, you got it. Case sensitivity is required for the time column.

0 Likes