Data Studio
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

CountIf Formula?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

What is it?

 

Count if column equals "Apple"

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Tony T
May

CountIf Formula?

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

SUM(CASE WHEN REGEXP_MATCH(Column, '^Apple.*') THEN 1 ELSE 0 END)

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Tony T
May

CountIf Formula?

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

SUM(CASE WHEN REGEXP_MATCH(Column, '^Apple.*') THEN 1 ELSE 0 END)

 

CountIf Formula?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks much

CountIf Formula?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

SUM(CASE WHEN <column> = "Apple"  THEN 1 ELSE 0 END )

CountIf Formula?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi, Can we able to do multiple case statements. Like Orange, Berry?