Reports ignoring same values

Ignition
1

I have a table in a Report Module that recieves its dataset from the Tag History binding. There is just too much data, I have the scan class set for every ten minutes but a lot the data is duplicated and often a whole year needs to be viewed in a report.

Is it possible to ignore data with the same value as the previous and/or next row in the dataset?

i.e.:
Row/Time/Value
0 / 1 / 6.00
1 / 4 / 6.00
2 / 6 / 6.00
4 / 9 / 4.50
5 / 12 / 4.50
6 / 15 / 4.50
7 / 20 / 19.00

in the example data from rows 1,2,5 & 6 would be ignored as duplicates. Leaving:

0 / 1 / 6.00
4 / 9 / 4.50
7 / 20 / 19.00

I could not find any other posts or was not able to search them out, if anyone can help or can direct me to another posting that would be great. Thanks

-Brian

2

OK, it actually looks like the data isn’t updating in my DB but still how can I eliminate unimportant values in the report table?
It seems to fake the time values for these to fill in the report but i end up with tens of thousands of rows of data…?

Thanks.

3

Yes, set your Sample Size to On Change in the tag history binding. It will only give you the rows when the value actually changed.

4

Thanks Travis!
You’re the man.