I have a table ‘hierarchy’ that in essence has the following schema:
primary_key (text)
name (text)
foreign_key (ref - hierarchy table)
level (number)
This table’s foreign key references the primary key of the same table (hierarchy).
I have created a slice for each level (up to 4) and want to present them in an interactive dashboard so that when you select a parent, it filters its children. This however does not seem to work. A selection of a parent (or child for that matter) doesn’t filter anything.
Is this by design?