I need to develop an equation where we want to compare current day production figure with average of three highest production figures in previous one week. Denominator will be average of three days of highest production in last week and numerator is current day production.

Appreciate if any one can guide me which function in AF analytics can be used for finding out average of three days of highest production.

Hello Kesu,

I wouldn't know any AF Analysis function or combination of functions which would return the average of the 3 highest values for a certain period. The next version of Asset Analytics introduces support for arrays, please see the PI System Roadmap for PI-AF, and this may change the picture.

Today I would use a programmatic approach by retrieving values through AF SDK and doing the analysis client side.