14 Replies Latest reply on Sep 10, 2018 5:38 AM by Kamin Au

    Distinct count broken down by region is not quite correct

    Kamin Au

      Hi,

       

      I can see how we can create distinct count calculations but I am having issues with getting the correct distinct count should I need a detailed breakdown.

       

      For example, the below has 5 distinct IDs, and i would like these 5 distinct counts to be broken down by region (maybe using some logic where we prioritize APAC over US  etc. should there be more than 1 region assigned to a unique ID). However, this currently, this would give me 7 distinct counts, so my total counts are inflated.

       

      Any suggestions will be much appreciated, thanks!

       

       

      Unique IDRegion
      111APAC
      222EMEA
      333APAC
      333EMEA
      444LATAM
      444US
      555LATAM