0

Can you change filter conditions in discoveries be OR rather than AND?

We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero.  So the condition would look like this:

Measure A !=0

or

Measure B !=0

Here is a screen  shot where I can filter but the condition is always and and so no rows are returned.

3 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    Build a 3rd measure that reflects your selection logic and use that in the filter.

      • Robert_Clark
      • 3 yrs ago
      • Reported - view

      avi perez thank you that’s what we ended up doing. I was just wondering if there was an easier way built in. 

      • "making the sophisticated simple"
      • AviPerez
      • 3 yrs ago
      • Reported - view

      Robert Clark Filters today are assumed to be nested - which turns them into "AND" (as you already know). The "OR" option is a possibility - but not enacted in the UI yet. For the time being, the measure approach produces the same outcome and is not any less efficient. 

Login to reply

Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 3Replies
  • 53Views
  • 2 Following