How do I divide the number of users from 2 different pages in Google Data Studio, using Scorecards?

Question

I want to divide 123 by 9.2k (to give a %).

• 123 = number of users on first page.

• 9.2k = number of users that go to the second page after visiting the first pace.

I want to calculate % of people going from first to second page.

Both data is from Google Analytics number of users.

Screenshot of Data Studio:

Answer 1

One way that it can be achieved by selecting both Scorecards, then right clicking either Scorecard to Blend data and create a Ratio Metric:

1. Left Click on Scorecard 1 (123 Users);

2. Ctrl + Left Click (on a Windows device, for a Mac use ⌘ + Left Click) on Scorecard 2 (9,200 Users);

3. With both Scorecards selected, Right Click on either Scorecard and select Blend data from the drop down to create a new Scorecard, a Ratio Metric.

Editable Google Data Studio Report (Embedded Google Sheets Data Source) and a GIF to elaborate: