Do I need to use Beast Mode to filter data in this way?

DannyLewis

I'm working on a sales dashboard and I've got a scenario where within a card I need to filter out pitches sent to internal staff unless they are tagged with a specific word (of 10 possibles) contained in a measure.

 

Is Beast Mode the solution and if so how would I do it? Any help much appreciated.

 

Cheers,

 

Danny

guitarhero23

Yes a beast mode should work out for that, I would also recommend adding that new calculated field to the filter and checking the "Quick Filters" box so that you can filter or unfilter it while on the card.

 

An option would be to use a case statement, something like

 

(CASE

WHEN `tag` = 'Internal tag #1' THEN 'Internal'

WHEN `tag` = 'Internal tag #2' THEN 'Internal'

WHEN `tag` = 'Internal tag #3' THEN 'Internal'

........etc

 

Else 'External'

END)

 

When you to it this way you could filter easily between internal and external (or show both). Let me know if you have any other questions or if you need help writing it provide me the column name and the 10 possible values you want to be able to filter out as internal and I'll write it up.