Forum Discussion
Related Tables; Graphics only update in 1 direction
I have two tables, with a '1-to-many' enforced relationship applied.
Table 1 = Projects
Table 2 = Benefits (each project has 1 or more benefits).
I have a Treemap visual for the Benefits. When I select a "Project-Level" value in a table or visual, the Treemap updates correctly; for example: One project is selected, the Treemap shows the one or more benefits for it. If a Project "category" is selected, the Treemap updates showing the benefits associated with projects in the selected category. Its working great, BUT.....
If I select a Benefit type (say "Quality of Life"), I was expecting to the other graphics to update to show only the projects that have that selected benefit in the related table. The other "project level" visuals/tables do not update. Any Ideas how to make this happen? Thank you! -M
Find the little arrow that is in the middle of your relationship line, thats the direction you can filter. So in this case, your project can filter benefits but benefits cannot filter project. 1 to many also doesnt seem to be the appropriate relationship if each benefit can also apply to 1 or more projects.
2 Replies
- Syk
Resident Rockstar
Find the little arrow that is in the middle of your relationship line, thats the direction you can filter. So in this case, your project can filter benefits but benefits cannot filter project. 1 to many also doesnt seem to be the appropriate relationship if each benefit can also apply to 1 or more projects.
AWESOME, Thank You!
