Use the OR Operator between filters

StavrosMcGillicuddy — Tue, 15 Oct 2024 16:03:39 GMT

My dashboard has several drop-down filter panes

As filter panes are “or” within themselves, using two or more filter panes are “and” between them

(Filter A(1 or 2 or 3)) AND (Filter B(4 or 5 or 6))

I need to add Filter C with an OR operator like this.

(((Filter A(1 or 2 or 3)) AND (Filter B(4 or 5 or 6)) OR (Filter C(7 or 8 or 9))

Filter C must be available to use with any of the other filters on my dashboard

I tried adding Filter C 7,8,9 into Filter B like this 7C,8C,9C. It works but it's clunky and not intuitive.

Is there a cleaner way to do this? Maybe dynamically build a search string that can be edited like SDFC & Marketo?

Re: Use the OR Operator between filters

Qrishna — Tue, 15 Oct 2024 20:00:17 GMT

Hi - some sample data and needed output pls? Filter as in the Filter pane object or the field name in the script?