Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a link table which essentially looks like this:
ID | Name | Responsibility |
123 | nick | captain |
123 | oliver | vice captain |
1456 | nick | team member |
1456 | oliver | captain |
1456 | sarah | team member |
and there are associations in the load editor based on the name and the ID.
I have a table in the dash that shows all the captains and vice captains as so...
name | responsibility (do not show if team member) | city | |
nick | captain | x | x |
oliver | vice captain | x | x |
oliver | captain | x | x |
right now if were to select oliver, sarah would also come into scope given she sits in the same team (ID)... how do i make it so when i select a name, for example oliver, only the teams Oliver is vice captain for comes into scope.
Unable to understand the problem here
but if you select Oliver there will be two rows one of oliver captain and another of oliver being vice captain, no row containing sarah would come.
This post sounds like another post from earlier in the week. It sounds like there is more to the data model than shown as selecting 'Oliver' should not show 'Sarah' based on the link table alone. You must have Sarah's name in another table that is linked by ID which means, any selection on the name (Oliver for example) is associating to other team members.
To filter based on name & responsibility at the same time (based on one click) you would need to create a 'calculated dimension' in the table that displays a concatenated value that preserves both parts of the context you want to filter on (name and responsibility) into a single field for the user to click
[name] & '-' & [responsibility]
When the user selects this value (ie Oliver-Vice Captain) it filters for rows where name=oliver and responsibility=vice captain at the same time.
If you don't produce this combined value , you would have to make 2 selections, one on name, and then a 2nd on responsibility to get it to filter to the same context.