/datastudio/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
Percentage of Row 0 Recommended Answers 16 Replies 129 Upvotes
1 Recommended Answer
$0 Recommended Answers
1 Relevant Answer
$0 Relevant Answers
Hello,

I am trying to create a pivot table which shows sessiones by device as a percentage on a a weekly basis, therefore I need the percentage of the row total. But I can only find the options as a column total.

It would look something like this:


Any help would be much appreciated.
Thanks
Relevant Answer Relevant Answers (0)
All Replies (16)
Relevant Answer
THE SAME HAPPENS TO ME
marked this as an answer
Relevant Answer
This is also needed to create cohort analysis charts.
marked this as an answer
Relevant Answer
YES. I posted about this last week. The only aggregation option & percentage display is actually for data studio to display the cell as a percentage of all data. So, % of website clicks from an iPhone is August is not possible. Instead, data studio displays that cell's value as a percentage of all data from all times. This is extremely unhelpful, and is a major bug in the system.
marked this as an answer
Relevant Answer
Same issue. Glad to hear I'm not alone, but I'm just as frustrated when realizing Data Studio doesn't provide percent of total (by row). 

Too many dates and cohorts to manually does this in SQL. SOS, Google.
marked this as an answer
Relevant Answer
Same issue, even for the line chart, there's no option to calculate the percentage of column total. 
marked this as an answer
Relevant Answer
Hey Sanita Banghard et al

Yes, the feature is currently not implemented.
How about a visualisation of the data  - 100% Stacked Column Chart?

Created a Google Data Studio Report (Google Analytics Sample Data Source) to demonstrate, as well as a GIF showing the process below (using the original post as an example).

1) Dimensions and Metric
- Dimension: Date (Week);
- Breakdown Dimension: Device Category;
- Metric: Sessions;

2) Sort
- Sort: Date (Week) in Ascending order;
- Secondary sort: Device Category in Ascending order;

3) Formatting (Style Tab)
- Breakdown (View Mode): (Tick) Show Total Card;
- Bars: Increase the number of bars (weeks) from the default 10 to 52 (or as required).


Hope this helps

marked this as an answer
Relevant Answer
Hello everyone, 

I would like to know if there is still no way to have a sum in percentage of the rows, directly in data studio
marked this as an answer
Relevant Answer
Still doesn't seem to be a solution for this.  Is there any way it can be done?
marked this as an answer
Relevant Answer
I am currently migrating all my reports which I created manually via SQL + Spreadsheets with pivot tables to Data Studio to automate the retrieval of newer data.
I have many Spreadsheet Pivot reports using the "Percentage of Row Total" feature so I urgently need this in Data Studio as well. Please Google, we need this!
marked this as an answer
Relevant Answer
Another key workaround here is building the % calculation directly into your SQL query. So then in your pivot table you take the raw cell outputs as literals, and they're now in % form!
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/datastudio/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/datastudio/profile/0