PI Datalink in Excel query

Discussion created by J.Roux on Sep 1, 2020
Latest reply on Sep 11, 2020 by Moshe Sabag

Good day, I am trying to retrieve & filter data to remove certain values (ex. all data <100) prior to calculating minimum, maximum, average and range values. The calculated data function can be used for the calculation (min/max/avg/range) but I am struggling to filter the data prior to the calculation. How can I use PI Datalink for this application?