The mighty pen of Google Data Studio wields a plethora of functions that give its users the power to manipulate data as they wish. If we travel a bit further down the rabbit hole of this powerful tool, we'll find that one of its mighty functions is the RIGHT_TEXT function.
To keep it simple, the RIGHT_TEXT function is the sharp ninja handyman in your toolkit that retrieves a specific number of characters from the end of any given text string. With this function in your knowledge arsenal, you can easily display your data the way you want to.
The syntax is the primary rulebook that guides the function's operation. The structure of the RIGHT_TEXT function is simple and straightforward:
RIGHT_TEXT(X, length)Don't let the simplicity scare you - there's power in simplicity. For this function, our syntax only requires two parameters -
XlengthXLet's dive right into some examples to better illustrate the functionality of this little ninja.
Let's say you've got a campaign for a big annual summer sale, and for your report, you are only interested in extracting the 'type' of offer from the name of campaigns, which is always at the end of the text string.
You could simply invoke:
RIGHT_TEXT("Summer Sale 20% off", 8)Your result would be: "20% off".
Or perhaps you'd like to know what product your team performed particularly well on.
RIGHT_TEXT("The working team achieve a 30% improvement in sales of Shoes", 5)Result: "Shoes"
By harnessing such examples of the RIGHT_TEXT function, you can easily and quickly retrieve valuable data, helping you understand different perspectives of the business.
The RIGHT_TEXT function, while powerful, is not without its limitations. The 'length' parameter cannot be negative, and non-integer values are truncated and not rounded. Be aware of these constraints when using the function.
To get the most out of the RIGHT_TEXT function, here are some quick tips:
In summary, the RIGHT_TEXT function in Google Data Studio acts as an invaluable ally in slicing and dicing your data into more understandable parts. Armed with this tool, you can delve deeper into your data, pulling out the key information you need, when you need it.
Become a Looker Studio expert
for free
Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.
Get more video lessons
All your data on Looker Studio
Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.
Start free trial now!
Optimize your data analysis
Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.
Get free templates!.png)
