I'm trending hourly data in excel. I only want the hourly values shown, to be included. However, when I perform "min" or "max", the values not shown in the cells are included. Was wondering how to not include those.
I'm not sure what you mean by "perform "min" or "max""...would it be possible for you to include some screenshots or additional explanation on this and which values you do not want included in the trend? I also want to verify that you are using PI DataLink to get the data and create the trend?
Okay, here are a couple screen shots. The data shows 21.4, 21.7, etc., which is 21,400, 21,700. The "min" shows 12,415, which its actually taking data from stuff other than what is shown on screen. I.e, between the times shown. So what I would like to do is use stats on only what is shown on the screen. Hope anyone can help. Thanks
Retrieving data ...