Unify two filters in one Beast mode function ?

Gor_Gonzalez

Hello,

In a card, I edited a Beast Mode function in order to combine two filters:

• (case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors'

else 0

end)

• (case when (`Country`='CountryB') then 'Distributors'

else 0

end)

I would like to combine these two in one unique Beast Mode function like a UNION function or a + function, however I can't find the good syntax for that.

Thank you in advance.

MarkSnodgrass

You would just create multiple WHEN statements. You can have as many WHEN statements as you want in a CASE statement. Yours would look like this:

(case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors'

when (`Country`='CountryB') then 'Distributors'

else 0

end)

MarkSnodgrass

@Gor_Gonzalez , you're welcome! If you can mark the answer as accepted, it will help others in the community.

Gor_Gonzalez

Thank you Mark for your help !