Data Studio
4.6K members online now
4.6K 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