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