How to apply case switch on boolean columns

Get Help
1

Hello !

I would like to create a custom column base on boolean columns, but can’t figure out the correct syntax. What I would like to do would look something like this :

newColum = case([is_valid], "Valid", [is_waiting], "Waiting", "Invalid")
or
newColum = case([is_valid] = true, "Valid", [is_waiting] = true, "Waiting", "Invalid")

However both of these are not considered correct. Am I missing something obvious ?

Thank you for your help,
Augustin

2

Hi @Augustin
There’s an issue open of it:
https://github.com/metabase/metabase/issues/12393 - upvote by clicking :+1: on the first post
Some databases might understand [is_valid] = 1 so you can try that.

3

Thanks for your answer. Already tried it but it doesn’t seem to work on PostgreSQL.

4

@Augustin Sorry, linked to the wrong issue - here’s the correct one:
https://github.com/metabase/metabase/issues/12393 - upvote by clicking :+1: on the first post