1 Reply Latest reply on Jun 13, 2016 9:30 AM by Tom W

help in multidimensional relationship

Jaymin Panchal Jun 12, 2016 4:31 PM

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

Emp Id	ID	Department	Department Id
230	100	IT	5
	101	IT	7
	102	IT	8
	103	IT	9
	104	IT	11
231	105	HR	100
	106	HR	13
	107	HR	16
	108	HR	19
	109	IT	20
	110	IT	22
	111	IT	54
	112	HR	32
	113	HR	28
	114	HR	79
	115	HR	83
232	116	HR	91
	117	HR	90
	118	HR	23
	119	HR	21

1. Re: help in multidimensional relationship

Tom W Jun 13, 2016 9:30 AM (in response to Jaymin Panchal)

You could create a calculated field like "HasITDepartment?" as COUNT(IF Department = 'IT' END) > 0
Like Show 1 Likes(1)

Actions

Tableau Community