6 Replies Latest reply on Jul 26, 2018 8:31 AM by Mahfooj Khan

    Count of an Aggregate

    Shahzad Zia

      Hi,  I'm a bit of a newbie on Tableau.  Can someone help

       

      I have some data as follows

       

      Company         Branch     Completed    

      Company A     Branch 1     Yes

      Company A     Branch 2     Yes

      Company B     Branch 3     No

      Company B     Branch 4     No

      Company C     Branch 5     Yes

      Company C     Branch 6     No

       

      I want to aggregate the data so i have only 1 line per Company which i have managed to do with Max function.  so

       

      Company A          Yes

      Company B          No

      Company C          Yes

       

      How do i do a count of Yes/No, i.e

       

      Yes = 2

      No = 1

       

      Thanks

       

      Shahzad