REGEXP_EXTRACT not working in Calculated Field[ Edited ]
April 2017 - last edited April 2017
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"