In tableau how to show unmatched row in my case?

Question

I'm new to tableau.

I have a data like this.

[department]

[employee]

And I want to get employee count under 30 age per department. like this..

[my goal]

I want to show all departments (if there is no employee)

To get result, I do these steps,

• make relationship of dept - emp (one datasource)
• make datasource filter (emp.age < 30)
• make sheet and set row as dept_no, countd(emp_no)

But I could only get like this.

[my result]

How can I get my goal..!!?? Help me!!

Answer 1

It is simple hereafter. Use join (instead of relationship) on the side of dept table and Take dept_no column from dept_table instead of emp_table. To do this follow these steps

• double click on first added table (say emp). A join window will open (thgis differs from relationship)

• add dept table and use right join

• right click age convert to dimension

• right click again age and convert to continuous

• create filter at most 29 on age and don't forget to check include null values in the table

• If you want to add all values in view. create a calc field with calculation as

INT([Age] <30)

• add sum of this field to view

• edit the calculation to show all nulls as 0

ZN(INT([Age] <30))