2 Replies Latest reply on Nov 26, 2015 3:12 AM by Mark Fraser

    tableau distinct count - first five digits only

    jonathan.swenson.0

      Hello,

       

      There have been some changes to our data where we use to use just a five digit number but with the new system there is a -01 or -02 added to the end of the data. For my purposes I only care about the first five numbers. Is there away to ignore the -01 in the exported data?

       

      Specifically how would I be able to see the distinct counts when looking at only the first five numbers?