# Time Series Chart. Binding to Data Property

**URL:** <https://forum.inductiveautomation.com/t/time-series-chart-binding-to-data-property/28181>\
**Category:** Ignition Early Access\
**Tags:** namedqueries, ignition80, database, perspective\
**Created:** [September 11, 2019, 5:08pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-binding-to-data-property/28181 "2019-09-11T17:08:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**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:** [September 11, 2019, 5:08pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-binding-to-data-property/28181/1 "2019-09-11T17:08:10Z")

</div>

I have a query

```auto
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

```auto
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](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3524a4439168be508af55ea6c9c147c29b840d96.jpeg)

It errors the component out.

this is how it’s set up from example.

![post2](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/25f7db885a36df26cbf335a0a282bbeb20b7769e.jpeg)

What am I missing?

---

<div class="post-metadata">

**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:** [September 11, 2019, 5:09pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-binding-to-data-property/28181/2 "2019-09-11T17:09:16Z")

</div>

Changed ‘Time’ to ‘time’.

TIME has to be lower-cased.

---

<div class="post-metadata">

**Author:** ![jball](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jball/32/11128_2.png) [@jball](https://forum.inductiveautomation.com/u/jball)\
**Post date:** [September 11, 2019, 5:51pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-binding-to-data-property/28181/3 "2019-09-11T17:51:56Z")

</div>

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