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