use a parent filter to select rows with interesting features, e.g. pass/pail = fail with "Conditional" activated, other filters will adjust accordingly e.g. batches will just shows batches with fail units
select all these batches
clear the filter selection for pass/fail you just filtered all batches with fail chips
Once you understand the magic behind it, it's a feature you won't want to miss.
This way, during exploratory data analysis, you can "stay in the flow" , just make one step after the other.
No need to create a column formula with grouped Col aggregation or similar workarounds.
B) Another benefit which cannot be rated high enough! It will save users hours of waiting time over the course of their working lives:
The current "clear all child-selections" mode for conditional data filters results in long graph rendering times:
Every time a selection is cleared, all child selections are cleared as well. No chance to restrict the plot to a subset! So, every the user has to wait dozens of seconds, or even minutes.
I often work with large data sets which can just be displayed efficiently if a subset is selected (!). The current behavior of Conditional Data filters is so time consuming that I decided to deactivate it.
Same for you?
The lock childs when clear mode will fix the issue: With the new behavior, the user can make a "dummy" selection (just a single row), clear all the other data filters, apply a new filter and then clear the dummy selection.
Important: the new mode should NOT replace the old mode.
There should be a switch in the red triangle menu to activate the cool new behavior - when it's needed. Or via the preferences: if it is needed frequently.
The new setting - activated when needed: - adjust child filters if a parent filter is changed (like before) - don't remove child filters if a parent filter is cleared via