i have a digital analytics exam tomorrow and this was extremely helpful so thanks a lot! I would also like to add that your way of explaining things is amazing and not boring at all
Great video. I have a dimension that consists of values of long strings of data, ie "the brown fox jumps over the lazy dog." How can I apply some kind of treatment to the value so that the first letter is always capitalized?
Auch, yeah, I do not think that is possible because if you next too many functions it will give you an error. Try this, REGEXP_REPLACE(REGEXP_REPLACE(LOWER("big dog runs fast"), '(^|\\s)([a-z])', '\\1\\U\\2'), '\\b(\\w+)\\b', '\\U\\1')
You will need to go into the style tab and select absolute value. That will create a total from date. then as long as you are grouped by week or month you should be good to go! Best of luck! - JJ
The only way to turn a calculated metric into a dimension is to use the cast function Here is a link to the documentation! support.google.com/looker-studio/answer/7280720?hl=en Best of luck! If you need help, join the weekly newsletter & hit reply on LookerStudio.VIP/cheatsheet
i have a digital analytics exam tomorrow and this was extremely helpful so thanks a lot! I would also like to add that your way of explaining things is amazing and not boring at all
Aweee thanks so much!
-JJ
Great video. I have a dimension that consists of values of long strings of data, ie "the brown fox jumps over the lazy dog." How can I apply some kind of treatment to the value so that the first letter is always capitalized?
Auch, yeah, I do not think that is possible because if you next too many functions it will give you an error.
Try this,
REGEXP_REPLACE(REGEXP_REPLACE(LOWER("big dog runs fast"), '(^|\\s)([a-z])', '\\1\\U\\2'), '\\b(\\w+)\\b', '\\U\\1')
@@Vision-Labshow did you learn Regrex?
@@katiam.6615 Practice :)
Regex101.com is great for practicing
- JJ
How Can I make my charts x-axis weekly or monthly dates and the Y-axis the sum of each week or month? Thanks!
You will need to go into the style tab and select absolute value. That will create a total from date. then as long as you are grouped by week or month you should be good to go!
Best of luck!
- JJ
can we turn a calculated metric into dimension?
The only way to turn a calculated metric into a dimension is to use the cast function
Here is a link to the documentation!
support.google.com/looker-studio/answer/7280720?hl=en
Best of luck!
If you need help, join the weekly newsletter & hit reply on LookerStudio.VIP/cheatsheet
@@Vision-Labs ❤️