Use visual builder to help define nested filter logic : ( (A OR B) AND (C OR D))...
Hi,
Posting this comment from @natejgardner
as a Dataiku Product Idea:
"It'd be great if the visual filter builder were able to support more sophisticated logic. Currently, all the filtered values need to be combined with either and or or, but in some cases, users might want to use nested logic without needing to write an expression using formula language or SQL. This UI handles nested logic pretty well. It'd be awesome if logic like this could be expressed visually, I think it'd speed up development quite a bit and also help users intuitively understand what they're filtering for.
( (Condition1 OR Condition2) AND (Condition3 OR Condition4) ) OR ( (Condition5 AND Condition6) OR (Condition7 AND Condition8) )
Let us know what you think by adding your vote (
Take care,
Ashley
Comments
-
Elie Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered, Product Ideas Manager Posts: 32 Dataiker
Hello @natejgardner
Congrats - we're adding this to our roadmap! While timelines are always tricky, we'll let you know how it's progressing as updates are available.
Elie
-
We did it! This idea has recently been delivered with Dataiku 11.
Checkout this video to see what it looks like:
https://content.dataiku.com/dataiku-11/visual-logicDSS filtering capabilities have been enhanced so that everywhere you can filter data, you are able to use nested and complex filters.
https://doc.dataiku.com/dss/latest/other_recipes/sampling.html#filtering-in-dss
A new step has also been added to the Prepare recipe to visually create If/then/else blocks
https://doc.dataiku.com/dss/latest/preparation/processors/create-if-then-else.htmlThis new step comes in handy when you need to handle more complex cases than what the Switch/case step supports
https://doc.dataiku.com/dss/latest/preparation/processors/switch-case.html