How to separate Metric by dimension in Google Data Studio?

1
votes

How to separate Sessions (metric) for each Page (dimension) in Google Data Studio?

1
data-visualizationgoogle-data-studio
Please update your question with the desired behavior, specific problems, and code to reproduce it. See: How to create a Minimal, Complete, and Verifiable example – abestrad

1 Answers

2
votes

It can be achieved by creating a REGEXP_EXTRACT Calculated Field to group the required section of the URL (in the case below, to capture all characters between the first / and and next /):

REGEXP_EXTRACT(Page, "^(/[^/]*)")

The Calculated Field above groups values in the Page field, as shown below with the New Page field:

Page New Page
/example/123/456/789 /example
/example/aboutus/more /example
/example/location/branch /example
/example/staff/department /example

Google Data Studio Report and a GIF to elaborate: