.png)
Looker Studio is great for handling percent fields, but you must know how it works and which options to use. We will see how to indicate to Looker Studio that a field is a percentage and the options to format it.
Each metric has a predefined format. You can change this format for a metric in a chart or across the entire report.
Select a chart, and click on the option for a metric:
Under Data Type, select Number -> Percent.
As you can see in my formula, I didn't multiply by 100. Looker Studio will do it.
Then, under Display Format, select the format you want or create one (if you wish to 2 decimals, take Percent(2).
Click Apply and wait for the chart to reload.
Here is the result:
{{cta-connect-looker}}
You can get the same result by editing the field type in your data source.
To do so, go to Resource -> Managed added data sources -> Edit your data source.
Then, select your field and change its type:
This will apply the Percent type to the CTR wherever you use it. But you will have to change the Display Format for each charts if it is not the one you ant by default.
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)
