3 Replies Latest reply on Mar 7, 2013 4:55 AM by Thomas Beaulieu

    count distinct problem on data containing strings and numbers

    Thomas Beaulieu

      Hello - I have data for order numbers that looks like this:

       

      123456

      123456

      234567

      C987654

      C987654

      C876543

       

      Using the count distinct function I would expect 4 as the answer but I end up getting 2.  When I plot the order numbers I get 123456, 234567 and Null.  I think tableau is treating the alpha numeric values as nulls and these nulls are not counted using count distinct.  Is there a solution to this that does not involve modifying my source data?  I have tried changing the data type to a string and a number but no luck.  I have also experimented with treating the filed as a dimension and a measure but again no luck.

       

      Tom B.