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

REGEXP_EXTRACT not working in Calculated Field

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

I'm trying to create a Calculated Field by manipulating an existing field exported from Big Query using REGEXP_EXTRACT.

 

Performing REGEXP_EXTRACT(textPayload, '(\d+\.?\d+)') returns either "Could not parse formula" or "Invalid Formula". The regular expression works find outside of Data Studio.

 

FYI, trying to extract the decimal from the following string: "throughput: 33.35"

 

Any ideas?