Hello Fellow LS users.
Thhis is a Link to Loom video with the issue:
https://www.loom.com/share/f87f6a26f0414e238ac0134459a1c1fc
And here some additionall info:
I am creating a GA 4 template based on original GA 4 data connector from Google.
I created a pivot table allowing to dynamically swap dimensions and break down them by sections of the webpage (like blog/homepage/services etc).
This case is for swapping dimensions:
case
when table_event = True then Event name
when table_page = True then Page path
when table_device = True then Device category
when table_country = True then Country
else Event name
end
This formula is extracting a certain path from my URL:
Case when REGEXP_EXTRACT( Page location, '^https://[^/]+/([^/]+)/' ) is null then 'Homepage'
else REGEXP_EXTRACT( Page location, '^https://[^/]+/([^/]+)/' )
end
The chart works just fine from time to time but then suddently out of the fog it crashes with an error:
"Data Studio Configuration errror"
When i see it i just click on the chart and in the properties click on each dimension and it magically rolls back to "fixed" mode (just like on the loom video".
Because this is going to be a template I would like others to use, I would rather want to have it worked properly and not instructing people to go in edit mode and fix manually.
Is enyone here able to help me with this particular error?
@Mehdi_Oudjida @dylantrose ?
Regards
Arkady Zagdan
LinkedIn
Twitter
