I need to build three dashboard as below. please advise how to achieve that by using multidimensional relationship.
1) should display all the records
2) Includes Emp Ids that have at least one IT as Department
3) Includes Emp Ids that do not have at least one IT as Department
You could create a calculated field like "HasITDepartment?" as COUNT(IF Department = 'IT' END) > 0
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...