2 Replies Latest reply on Aug 17, 2018 11:49 AM by Pearl.pat.0

    Median for 12 months

    Pearl.pat.0

      Hi

       

      My scenario is something like I have need calculate median for 12 months. But here I have only 2 months which has complaint.

       

      Before I was using something like this to calculate median :

      { FIXED [Product], [Complaint] :  MEDIAN({ INCLUDE [Year-Month]: COUNTD([Complaint No])})}

       

       

         

      ProductComplaintYear-MonthComplaint No
      ABCClose2017-025
      ABCClose2017-053
      XYZIn progress2017-011
      XYZIn progress2017-032
      XYZIn progress2017-041

       

       

      Thanks