3 Replies Latest reply on Jul 2, 2018 7:20 AM by Zhouyi Zhang

    Median of Distinct Count of records

    Keith Cheung

      Hello there - haven't been able to figure out how to get the Median for distinct count of records.

       

      In my case, I have a set of merchants (is client 'yes' & 'no') and each merchant has a different number of course ID.

       

      I calculated the number of course ID (using COUNTD(course id) & LOD) but both way couldn't get me the the median of the number of course id for the "Is Client" type.

       

      Tried MEDIAN { FIXED [Is Client],[Merchant Name] :countd([Course Id])} but it returns the same result for not using the MEDIAN function.

       

      And I can't use MEDIAN (Course id) as it's not a numeric value. Any help is much appreciated!!

       

      Screen Shot 2018-07-02 at 6.28.38 PM.png

       

      Keith