FILTERING VISUALS WITH MULTIPLE CRITERIA ON SAME NUMBER

calvert_schaefer

I have a variance % measure in beast mode. I am trying to filter the chart to show me anything >= 15% OR < = -15% however when I try to apply filters to the chart in edit analyzer, I do not see a way to add in an or statement based on my measure. Is there a way to do this in Domo ?

I'm really hoping to avoid having to do another beast mode that takes the absolute value of my variance calc and using that as the filter criteria.

ColemenWilson

You could create a beastmode and use that as the filter. Something like this:

CASE WHEN `Variance` >= .15 OR `Variance` <= .15 THEN 'In' ELSE 'Out' END

Then drag the beastmode field into your filter in card analyzer.

MichelleH

@calvert_schaefer The absolute value option is likely the simplest way to do what you're describing. You could also add a request to the Ideas Exchange to add a "Not Between" option to quick filters.

ColemenWilson

You could create a beastmode and use that as the filter. Something like this:

CASE WHEN `Variance` >= .15 OR `Variance` <= .15 THEN 'In' ELSE 'Out' END

Then drag the beastmode field into your filter in card analyzer.

MichelleH

@calvert_schaefer The absolute value option is likely the simplest way to do what you're describing. You could also add a request to the Ideas Exchange to add a "Not Between" option to quick filters.