Tags
Data TransformationText Functions
Chapter
Chapter 5: Working with Text
5.6. Text Functions: LEFT_TEXT() and RIGHT_TEXT()
Just like in Google Sheets, LEFT_TEXT() & RIGHT_TEXT() are another text functions that allows us to extract a part of a text field according to the number of characters we indicate in the formula.
These text functions are valuable when grouping campaigns or other dimension categories.
Enroll in Looker Studio Masterclass →
📩 Receive my weekly Looker Studio tips
🖇 Connect with me on LinkedIn