Ignition 7.9.10 Trends

[Matrix_Engineering]

EasyChart : write SQL Query myself

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…