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

How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

I am very new to these types of applications as well as google sheets. Was wondering how I might total a full column of figures in a table I inserted.

 

Any help would be very much appreciated

 

Best

 

Patrick

1 Expert replyverified_user

Re: How to Total a data metric on a table?

Top Contributor
# 2
Top Contributor

Hi Patrick,

 

I fear what you're asking is a bit out of scope for an Analytics forum but I'm going to try anyways.

 

You can read all about sheets and how to format them as well as create calculations and formulas here: https://support.google.com/docs/answer/6000292

 

But it sounds like all you want to do is total the columns - use the sum formula or you can try the function button as a shortcut - it looks like this:

 

function.png

 

-Tommy

Tommy Sands, AdWords Top Contributor | Community Profile | Twitter | Philly Marketing Labs
Did you find any helpful responses or answers to your query? If yes, please mark it as the ‘Best Answer.’

Re: How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Hey Tommy,

Thank you for the reply.

I still cannot seem to figure it out. I know how to apply the SUM function in sheets but still not sure how to in the report editor in Data Studio.

Best

Patrick

Re: How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Data Studio's' Tables do not have Total Rows. You either need to create a custom table in Sheets that has a total row or you have to use the metric widget to display the totals for the metrics you are interested in. Hopefully the devs can give us the option to add a total row or column to Tables in DS because this would be helpful and it would save a lot of real estate in many situations.

How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Where do you add a metric widget? I dont see it in Data Studio 

Re: How to Total a data metric on a table?

Follower ✭ ✭ ☆
# 6
Follower ✭ ✭ ☆

The only way I've found to show totals of a metric is with the Scorecard:

 

Capture.PNG

 

Hope this helps Smiley Happy

How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Hi there.

Yes, the scorecard can be useful but not when building a time series Smiley Sad

If anyone found a way how to do it please let me know.

Best,
BF

How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

You can add a Filter Control. By default it has the option "Show Values" which is the total sum for that metric you are filtering.

How to Total a data metric on a table?

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

Thanks!  This is a goood workaround!

How to Total a data metric on a table?

Explorer ✭ ✭ ☆
# 10
Explorer ✭ ✭ ☆

total row in table was added today.