Using the UPPER Function in Looker Studio for Text Modification and Data Presentation

 Using the UPPER Function in Looker Studio for Text Modification and Data Presentation

In Google Data Studio, the

function is a handy feature that can be used to convert any text, field, or expression containing at least one field to uppercase. If you're looking to standardize your text fields or highlight specific elements in your reports, the UPPER function has got you covered.

The syntax of the function appears as

. In this equation, X represents the text string input that you want to convert to uppercase. The string can be a literal text, a field, or an expression containing a field. It's simplicity itself to use.


function operates by transforming every lower case character in your chosen text string into an uppercase one. For example, if you want to record campaign names or product names in your data uniformly or wish to emphasize certain metrics by showing them in uppercase, this function makes that transition seamless.

While useful, the

function doesn't support wildcards. So, you can't use wildcard characters to identify subsets of strings to convert to uppercase.

Keep in mind that UPPER function, like other text functions in Google Data Studio, doesn't modify the original data. It only changes the display of the data in the report.

Moreover, while the UPPER function works well for Latin alphabet characters, it may not function consistently for all special characters in other alphabets.

Let’s look at some sales metric examples using the

function. Suppose we have the following sales campaign names and we used the UPPER function to transform them:

Upper("Winter Sales 2020") => 'WINTER SALES 2020'

Upper("spring discount") => 'SPRING DISCOUNT'

Note that the

function also applies to the numbers and special characters, allowing uniformity in text data even when they include such elements.

Another typical use-case would be in sales metrics for the Product Name field:


Here, the function has capitalized all the product names, making the data more uniform and easier to read.

There are some limitations to the UPPER function. The function does not support wildcard characters, and therefore you cannot use them in the text string. Additionally, when dealing with special, non-Latin characters, the function may not deliver consistent results.

In summary, the

function in Google Data Studio is a powerful, easy-to-use tool for text modification. Its seamless integration and applicability to reports make it a valuable resource in presenting data.

More function to use with Looker Studio

Introduction to the CONTAINS_TEXT Function
Mastering the Advanced REGEXP_REPLACE Function in Looker Studio for Effective Data Transformation and Cleanup
Mastering the DATETIME_SUB Function in Looker Studio: A Guide to Manipulate Date and Time Information in Your Datasets
Exploring the POWER Function in Looker Studio: Syntax, Usage, Examples and Tips for Data Analytics
Understanding and Utilizing the NULLIF Function in Looker Studio for Comprehensive Data Analysis