AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5K members online now
5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Calculating from a value to its percentage

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

 

I have many users from different counties. I can create a report showing me the raw count the number of users from a country. Say out of 100,000 users, 20, 000 are from US. Now, how do I show the percentage, 20% for US in this case, instead of the raw number? Creating a calculated field did not work.

 

Thank you!

1 Expert replyverified_user

Re: Calculating from a value to its percentage

Top Contributor
# 2
Top Contributor
Hi,
normally you should be able to do this but apparently there is an issue with aggregations.
You would need to look into the list of available functions:
https://support.google.com/360suite/datastudio/table/6379764
VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan