If you want to calculate the ratio of Staff to Managers and show it next to the Staff and Manager counts, the easiest way I can think of is to create 3 calculated fields:
Number of Managers = COUNT( IF [Manager/Staff] = "Manager" THEN [EMP ID] END)
Number of Staff = COUNT( IF [Manager/Staff] = "Staff" THEN [EMP ID] END)
Number of Staff per Manager = [Number of Staff]/[Number of Managers]
Then show them all on a table:
Is this what you are looking to do? See attached.
Note the calculations assume employee IDs are unique.
Sample_tableau.twbx.zip 15.9 KB
Thanks Pedro, thats what I was looking for.