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

Regex Match and Filters in Data Studio

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

Hello, 

 

I'm trying to extract part of a url and rename it "Friday, March 31" and then use it in a filter in Data Studio. 

Formula:

CASE WHEN REGEXP_MATCH(Page, '/2017/2017-03-31/') THEN "Friday, March 31" ELSE "Other" END

 

It's only returning "Other" in the filter. Am I using the right formula?

 

Thanks, 

Kate