2 Replies Latest reply on Nov 2, 2018 2:55 AM by Yun Feng

    How to calculate average value of each group based on date range?

    Yun Feng

      Hi

       

      I have data like this:

      标题 1标题 2标题 3
      DATEPRODUCTVALUE
      20180101A1
      20180102A2
      20180103A3
      20180101B5
      20180102B6
      20180103B7

      I have put the DATE in the filter, if I select range from 20180102 to 20180103, how to get the average value of A and B which are: (2 + 3)/2 = 2.5 and (6+7)/2 = 6.5?

       

      Thanks!