AnsweredAssumed Answered

Selection of three highest values in a week

Question asked by keshu74 on Apr 11, 2018
Latest reply on Apr 11, 2018 by Dan Fishman

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.

Outcomes