6 Replies Latest reply on Sep 22, 2014 7:29 AM by Toan Hoang

    Count distinct as a percentage of total - across: inaccurate percentages displayed

    Josiah Hart

      I'm working with a data set that has multiple lines for each Call ID which is a unique number. To eliminate duplicate records for each Call ID, I'm utilizing COUNTD.

       

      The issue that I'm unable to resolve is that when I convert this distinct count to a "percentage of total" and then edit the calculation to reflect across the table, the values add up to more than a 100%.

       

      Not sure what tableau is doing over here. Any suggestions?

       

      Thanks,

       

      Josiah