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

Google Data Studio

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

I'm trying to get some data to display after using a custom variable.

 

The Formula is parsing OK, despite my limited Regex knowledge, but so far I've had 3 system errors

 

CASE WHEN REGEXP_MATCH(Event Action, 'Buy Online') THEN 1 ELSE 0 END

 

ed61c361 - The server encountered an internal error and was unable to complete your request.

7a6e83f0 - The server encountered an internal error and was unable to complete your request.

05371a3a - The server encountered an internal error and was unable to complete your request.

 

Otherwise the graphs are loading ok. Very frustrating. Any help is much appreciated.

Google_Data_Studio.jpg

Google Data Studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Try this - CASE WHEN REGEXP_MATCH="Buy Online" THEN "1" ELSE "0" END

 

Gregg

Google Data Studio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I've got it to work, but st the moment it is only displaying as a Dimension and not a Metric. I'd like to have a double axis-ed graph with sessions on the left and buy online clicks per day on the right hand axis.