3 Replies Latest reply on Feb 1, 2017 8:35 AM by Allen Dsouza

    How to find count of employees in Both but with a condition. Any better way to do what I have achieved so far

    Allen Dsouza

      Hi,

       

      I am new to Tableau; I have the logic and the ideas but cant figure how to do it in Tableau.

      I have 4 columns

      Emp id          Food item          Burger king hrs          Mc Donalds hrs

      11062
      11103
      21240
      31334
      31403
      41102
      41204
      51105
      61104
      71140
      71250
      81130
      81309
      91109
      91209

       

      I want to find the number of employees in both, only in Burger King, only in McDonald's  (I was able to find the count in tableau using simple calculated fields)

      Now I want to find out the number of employees in Both but where McDonald's had a food item that Burger king didn't (Logic : Find employees in both and where Burger King hrs = 0).

       

      I was thinking of using the emp ids found in worksheet 3 in a new worksheet. Can this be done or Is there any better way to do this?