2 Replies Latest reply: Feb 12, 2018 7:39 PM by Digvijay Singh RSS

    How to create a set analysis for calculating average

    Anitha Lux

      I need to create a set analysis expression for :

       

      Avg( field_value when max of selected date , field_value when max of selected date) . How is this possible?


      Basically I have a table with counts for a yearmonth date. So foa a selection made I need to do an average of the count between the max and min selected date.