I’m a new user and I need to create a visualization sourced from multiple tables. I can create the individual visualizations easy enough. Viz1 is based on Table1. Viz2 is based on Table2. Etc.
There is a common identifier that links them, although the number of rows per uniq ID varies between tables.
How can I create the filter such that a filter applied to Viz1 also filters the rows in Viz2, and a filter applied in Viz2 also filters the rows in Viz1. I’ve read about parameters, and scope and more until I’m just completely turned around.
Joining the tables seemed a good idea at the time, but I can’t keep the records sufficiently distinct in the data model tool.
It seems like this should be straightforward.