# Ignition 7.9.10 Trends

**URL:** <https://forum.inductiveautomation.com/t/ignition-7-9-10-trends/29809>\
**Category:** Ignition\
**Created:** [November 8, 2019, 9:35pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-10-trends/29809 "2019-11-08T21:35:04Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [November 10, 2019, 12:06am UTC](https://forum.inductiveautomation.com/t/ignition-7-9-10-trends/29809/13 "2019-11-10T00:06:28Z")

</div>

> [@EasyChart : write SQL Query myself](http://forum.inductiveautomation.com/t/easychart-write-sql-query-myself/10181):
>
> Hello, I have an easy chart and I want it to display only a few points from my table. I don’t want it to display every grid line, but only every second or third… grid line of the table. Here is the SQL query of what I want to do: SELECT \* FROM ( SELECT myValue, myDate, ROW\_NUMBER() OVER (ORDER BY myDate) AS count FROM myTable ) x WHERE x.count % 2 = 0 And here is the result: -6,499901 2013-11-07 20:00:00.000 2 1558,476 2013-11-07 20:00:00.000 4 101,4985 2013-11-07 20:00:00.000 6 -19,4997…

---

_[View the full topic](https://forum.inductiveautomation.com/t/ignition-7-9-10-trends/29809)._