2 Replies Latest reply on Mar 25, 2019 9:02 AM by Jim Dehner

    Count Number of IDs in a State

    Sanjay Sinvhal


      My Tableau dataset is in excel.

      It has an ID field and US States field 'State'. ID is nothing but Serial Nos so Numeric. State is Text field

      I need to count and display the No of IDs in each state on USA Map.

      Eg NJ has 23 IDs

      What field I create and what scripts I write. Please help

      Thanks in advance

        • 1. Re: Count Number of IDs in a State
          Naveen B

          Hi Sanjay,


          Create a calculated field called COUNTD(ID)

          Then drag this field to text on the map


          Hope this helps

          Plz mark this answer as correct or helpful to close the thread

          If it didn't help attach a workbook along with the expected O/P to help you further




          1 of 1 people found this helpful
          • 2. Re: Count Number of IDs in a State
            Jim Dehner

            There are several ways to do this

            Just put state on the canvas (drag it there) and it will create a map

                      then do something like this




            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

            2 of 2 people found this helpful