Bitrix24Care

Use of regular expressions in Google Data Studio

In Google Data Studio, you can use regular expressions in the report.

You can study all available formulas in Google Data Studio documentation.

How to work with regular expressions

For example, you can use a regular expression to separate the name of a deal status from its identifier and display the information in a separate field.

First, create a new column for your table. To do this, click Add dimension > Create field.

Then specify a name and write the formula in the corresponding field. For example, the REGEXP_REPLACE(Stage, '\\[.+\\] ' , '') formula, to separate the name of the deal status from its identifier.

After that, a new column will appear in your table without the stage identifier. Thus, you can separate the information in the fields and display it in other columns.
Was this information helpful?
Integration specialist assistance
That's not what I'm looking for
Complicated and incomprehensible text
The information is outdated
It's too short. I need more information
I don't like the way this tool works
Go to Bitrix24
Don't have an account? Create for free