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

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?