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