I have 2 bar graphs on 2 separate ontology objects. These ontology objects are linked - is there a way to pass the filtered output of one graph to the other graph so that clicking on a bar in one graph would filter the data for the other bar graph? I know this can be done if you have 2 bar graphs using the same ontology object, but can’t figure out if there is a way to filter data on 2 linked objects. This would be functionality similar to how tableau works.
Hey,
Yes this is possible, but you’ll need to set up your Workshop variables accordingly.
Here’s an example with notional data, also using two Object Types that are linked to one another (dining establishments like food stalls and restaurants, and notional transactions):
1. No Selection
2. After Selecting a Specific Bar
The above example only uses 4 variables, 3 of which are object sets while the last one is an object set filter variable. Below is what the dependency graph looks like (variables in orange, the two chart widgets in blue).
- In the widget configuration panel on the right for your “starting chart”, click into the Layer where you provided an input object set.
- Scroll to the bottom, and create a new object set filter variable via the dropdown in the Selection as Filter segment.
-
Create a new object set variable (i.e., Filtered ) whose starting object set should likely be the same one you used as the first chart widget’s input, then apply a filter using the variable you created in the previous step.
-
Create a third object set variable whose starting object set should be your filtered object set (from step 3), and then search around to desired Object Type B. This will make its value dependent on any user selections made on your first bar chart.
-
Use the latest variable as the input to your second Chart widget.
Hope this helps!
1 Like
Thank you! This definitely helps! So I set it up - my only question is can you only filter from the first object to the second? Not the other way around? Because it works fine when clicking on a bar from the first object. But if I start with the second object I get this:
Yup that’s correct; if you check the variable dependency graph the lineage of variables and widgets should always flow from left-to-right. If you try also filtering the starting object set by an output filter variable from the second chart, a circular dependency is introduced.
That makes sense. Okay thank you again!