I have three entity types:
- Team (has field_company which is an entity reference to Company)
- Employee (also has field_company, and field_team which is an
optional entity reference to Team)
The idea is that all Employees are at least part of a Company, and possibly part of a Team within that Company. Using the Reference Field Option Limit module I have limited the options shown for field_team to only show Teams for the selected Company.
So far so good.
Now I want to create a table view with the following columns:
- Company Name
- Team Count
- Employee Count
I have created two relationships to referencing entities for field_company, and created a type filter for their types (Employee and Team). The problem is that Companies with no Teams, or no Employees are filtered out.
Any help with solving this deceivingly simple problem would be greatly appreciated!