Unify two filters in one Beast mode function ?

Gor_Gonzalez · 2021-04-13T17:01:33+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Accepted answers

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.

All comments

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)

Gor_Gonzalez

Thank you Mark for your help !

MarkSnodgrass

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