Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

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  ( ⬆️ = yes, please!) or comments.

 

Take care,

Ashley

4 Comments
AshleyW
Dataiker
Dataiker
Status changed to: Acknowledged
 
AshleyW
Dataiker
Dataiker
Status changed to: In Backlog
 
ElieA
Dataiker
Dataiker
Status changed to: Planned

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

apichery
Dataiker
Dataiker
Status changed to: Delivered

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-logic

DSS 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.html

 

This 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