Count the number of blank rows in a column using the custom expression for a custom column

Get Help
1

Can you please give some insights on how I can proceed Counting the number of blank rows in a column using the custom expression in a custom column?

As you can see obviously there blank rows in “Users - Owner → Invitation Token” ( see highlighted part on the table)

But after performing custom column of case(contains([Users - Owner → Invitation Token], ""), " Blank")

It returns zeros for the CountIf([Invt_Tkn_Blnk] = " Blank")?

1
11005×697 28.1 KB
2
2972×538 17 KB

2

Hi @aramit
Are you sure those cells are empty strings, or are they perhaps null?
Why don't you just do CountIf(isempty([Users - Owner → Invitation Token])) ?
For reference: https://www.metabase.com/docs/latest/users-guide/expressions.html

3

Your hint works! thanks alot @flamber