# Time Series Chart in Perspective using Database Named Query

**URL:** <https://forum.inductiveautomation.com/t/time-series-chart-in-perspective-using-database-named-query/102661>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [February 20, 2025, 8:51pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-in-perspective-using-database-named-query/102661 "2025-02-20T20:51:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kameron.swenson](https://avatars.discourse-cdn.com/v4/letter/k/3ab097/32.png) [@kameron.swenson](https://forum.inductiveautomation.com/u/kameron.swenson)\
**Post date:** [February 20, 2025, 8:51pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-in-perspective-using-database-named-query/102661/1 "2025-02-20T20:51:15Z")

</div>

Trying to get a dataset to populate in a time series chart. Everytime I try to use a database query I get component error on the chart. Following the documentation I placed my timestamp first and that is datatype DateTime in sql server followed by MetricValue which is just a decimal value. I added the MetricValue column under trends in the props section. Not sure what I am missing any help would be great.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/8/e85e8664e5bed318df1faa2e80215979bfe71ae0.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/5/5588163edf1605282c895b921255cf5224af1ee6.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/a/0a4d881dcabc9033a322a35599c8fcc35305d130.png)

---

<div class="post-metadata">

**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 20, 2025, 8:57pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-in-perspective-using-database-named-query/102661/2 "2025-02-20T20:57:11Z")

</div>

Your timestamps do not appear to be in order. Add an ORDER BY clause to your SQL.

---

<div class="post-metadata">

**Author:** ![kameron.swenson](https://avatars.discourse-cdn.com/v4/letter/k/3ab097/32.png) [@kameron.swenson](https://forum.inductiveautomation.com/u/kameron.swenson)\
**Post date:** [February 20, 2025, 9:01pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-in-perspective-using-database-named-query/102661/3 "2025-02-20T21:01:19Z")

</div>

Still doesn't work

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d6f3ebb8a26ae0e236da6a4a39b5830a7950d3e1.png)

---

<div class="post-metadata">

**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:** [February 20, 2025, 10:01pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-in-perspective-using-database-named-query/102661/4 "2025-02-20T22:01:48Z")

</div>

Right-click on the chart in the Project Browser, copy, and paste the code in here. See [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).

Do the same with the Perspective Property Editor "series" property as we won't be able to reproduce the dataset and will need your data for testing.

We can then reproduce the problem.