Hey, great video and clear explanation! I was wondering if it also possible to link another table to blend with the created dimension tag? Because I am currently stuck there. In my case the article tags are different kind of numbers in the text format, so just like you did I created an extra dimension with every number on his own but still corresponding to 'pageviews'. But now I need to add another database to this blend with the join connection 'tag' but this one is not available in the blend for me to connect. Do you have a solution for this?
Is there a formula to achieve this for values separated by space and not commas Also, blending in data studio now requires a connector join, should this be outer join?
Hi Apu, You just need to adapt the separator character regarding the formulas. probably just replacing red commas to spaces. For the blending, you need to use cross join (no join key). cheers
Great solution! Thanks for sharing.
Hey, great video and clear explanation! I was wondering if it also possible to link another table to blend with the created dimension tag? Because I am currently stuck there. In my case the article tags are different kind of numbers in the text format, so just like you did I created an extra dimension with every number on his own but still corresponding to 'pageviews'. But now I need to add another database to this blend with the join connection 'tag' but this one is not available in the blend for me to connect. Do you have a solution for this?
Hi Simon,
not sure to understand your use case but you probably could blend your database if there is a key to join data with a new additional table.
Is there a formula to achieve this for values separated by space and not commas
Also, blending in data studio now requires a connector join, should this be outer join?
Hi Apu,
You just need to adapt the separator character regarding the formulas.
probably just replacing red commas to spaces.
For the blending, you need to use cross join (no join key).
cheers
@@mehdioudjidasanalyticsvide6699 appreciate the response, tysm