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

Exclude a goal if previous step contains

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have this calculated field but the SUM is not working it just shows 1 or 0

 

SUM(CASE WHEN REGEXP_MATCH(Goal Previous Step - 1, '.*lp-.*') THEN 0 ELSE 1 END)