Skip to main content

Hi all,

 

I was wondering how to count the number of each unique dog within a total number of dogs per state.

So in the example below, if we look at the highlighted bar, we can see that there are a total of 24 dogs in south dakota, and 16 of them are different breeds. So for each different breed, I want to see how many there are.

 

My viz: Tableau Public

 

7 answers
  1. Dec 23, 2019, 8:42 PM

    In regards to the SD example, yes, I see 24 dogs and 16 breeds.  Are you wanting to see how many dogs are within each breed?  If that is the case, I would just build a table.  See below where you see the count of each breed within each state.  Attached is an example workbook, see the green worksheet.

     

    In regards to the SD example, yes, I see 24 dogs and 16 breeds. Are you wanting to see how many dogs are within each breed? If that is the case, I would just build a table.

0/9000