So I get that if I have a simple Ref relationship between two tables, create views for those tables and stick them together in an Interactive Dashboard magic happens and when I select a row from one of those tables, associated rows appear in the other table.
To go a little deeper, does this really work because of the “Related” lists that are automatically created for us when we setup the Ref column?
And if so, what happens when we start slicing the data?
As an example, I have Technicians who are carved out of a list of Employees using a slice. Work Orders have a Ref column for Technicians based on that Slice. But, I also divide Work Orders into Estimates and Service Orders with Slices.
When I attempt to create an Interactive Dashboard, using a view based on the Estimates Slice and another view based on the Technicians Slice, my hope was that the Estimates would be filtered by the chosen Technician. Alas, it doesn’t work (sigh). My thought is that maybe the Estimates can’t be properly filtered due to all of the slicing of the data.
So, again, at a deeper level, what is required between the two tables to get the filtering to properly work? Can I create some additional thing manually to make it function?