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
3K members online now
3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How to divide 2 scoreboard values to each other?

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I created a page with Datastudio. I have 2 values on the scoreboard. The data comes from Google analytics and each of these 2 scoreboards has distinct filters.

I would like to print values of (Scoreboard 1 / Scoreboard 2) and print to somewhere as a text or to another scoreboard. 

How can I do this with DataStudio?

How to divide 2 scoreboard values to each other?

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I'd love to know how to do this.

How to divide 2 scoreboard values to each other?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Similar request, a little more general:
I've 2 values from 2 sources and I want to print a scorecard with the rate ( value1.source1 / value2.source2 ). Is this possible?

How to divide 2 scoreboard values to each other?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I would like to know how to do this this, too!

How to divide 2 scoreboard values to each other?

Follower ✭ ☆ ☆
# 5
Follower ✭ ☆ ☆

You can do it only if the values from Scoreboard 1 and Scoreboard 2 have the same data source, by creating a calculated field. 

If they have different data source, the only way is to go through a Google Sheet. 

 

Hope it helps!

How to divide 2 scoreboard values to each other?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Is it possible if they have the same data source but both scoreboards have different segments applied to them?

How to divide 2 scoreboard values to each other?

Participant ✭ ✭ ☆
# 7
Participant ✭ ✭ ☆

You might need a case statement in that case, to create new metrics that are segment-specific.

How to divide 2 scoreboard values to each other?

[ Edited ]
Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Hello @Alessia C,

can you help me with this?

I have google analytics data source

and one segment (session scope)

I want to get (segment's #sessions) / all sessions

 

What I have done:

I made 2 scorecards,

the first one for the whole data source

and the other with segment. Here I made a calculated field representing the segment's #sessions.

However when I try to make another segment-free scorecard, I get wrong number for the calculated field.

Is this a wrong way? Is there another way?

Thank you!