2 Replies Latest reply on Apr 11, 2018 1:21 PM by Dan Fishman

    Selection of three highest values in a week

    keshu74

      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.