1 Reply Latest reply on Nov 11, 2016 5:17 AM by shripal gandhi

    Dummy ID or Primary Key

    simon baster

      Hi,

       

      my data does not have a unique number for each line of data.  Can I create one in Tableau?

       

      Thanks

        • 1. Re: Dummy ID or Primary Key
          shripal gandhi

          Hello,

           

          Below are the steps, you can follow :

           

          - Create calculated field with a '1' in it

          - Add that to your table as the measure and use 'Count Distinct'

          - Add a 'Running Total' table calculation to that measure

           

          Your rows will increment sequentially now. 

          1 of 1 people found this helpful