Hello, I pull data into excel from a Pi Tag dataset using PrevVal('tag','*')=0 because I want all the first highest point data following a low point zero. However, the odd event occurs where my data displays zeros because something happened in the trend (the red circles in the picture). I'd like to also filter those zero outs in addition to my current filter. How would I do that?
Thank you.