# Sparkline doesn't show future data

**URL:** <https://forum.inductiveautomation.com/t/sparkline-doesnt-show-future-data/6256>\
**Category:** Ignition\
**Created:** [April 17, 2013, 8:43pm UTC](https://forum.inductiveautomation.com/t/sparkline-doesnt-show-future-data/6256 "2013-04-17T20:43:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [April 17, 2013, 8:43pm UTC](https://forum.inductiveautomation.com/t/sparkline-doesnt-show-future-data/6256/1 "2013-04-17T20:43:07Z")

</div>

I’ve being playing around with the sparkline and discovered that it will not return historical data with a time stamp in the future. The easy chart has no problem with this. What is the difference in the SQL that would cause this?

(The data is in the future because it’s been stored with a GMT time stamp)

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [April 18, 2013, 3:55pm UTC](https://forum.inductiveautomation.com/t/sparkline-doesnt-show-future-data/6256/2 "2013-04-18T15:55:49Z")

</div>

More confusion. I waited over night in order to get data stored in my timezone. But it still refused to retrieve data from the history db. I then changed the time source for the tags to be system and immediately got a full trend. ![:/](https://us1.discourse-cdn.com/inductiveautomation/original/1X/8e510869ae26fbd7ab76e1e731ceea2054ef109c.gif "Hrm")

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [May 20, 2013, 9:23pm UTC](https://forum.inductiveautomation.com/t/sparkline-doesnt-show-future-data/6256/3 "2013-05-20T21:23:50Z")

</div>

I think you’re barking up the wrong tree. The sparkline will just draw whatever datapoints it is given, past, present, or future. I think maybe your queries weren’t returning anything? Maybe a time mismatch between the dates you were passing to the query system (sqltags history? raw query?) and how it was interpreting them?

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [June 20, 2013, 8:21pm UTC](https://forum.inductiveautomation.com/t/sparkline-doesnt-show-future-data/6256/4 "2013-06-20T20:21:22Z")

</div>

Sorry Carl, I missed your reply.

You could be right. I’ve been unable to reproduce the problem since then.