I use PI DataLink on Excel and more precisely the Calculated Data mode to get data for a long period with a 10min time interval.
I want to get rid of interpolated or "frozen" data on each 10 min point so I use the filter with EVENTCOUNT('tag')>=1.
It works well but the problem is that the running time is really long when I use this filter.
So do you have any idea to have the same results with a shorter running time? Any other methods?
Thanks in advance!