CODEWITHSUNDEEP
looker-studio
Fauz
Fauz

Reputation: 89

Is it possible to reference scorecard results into another scorecard?

I have two scorecards, each with a different filter applied. I am currently creating the following percentage calculation, manually: 

Scorecard A / Scorecard B

I would like to be able to automate it. I tried to reference the scorecards into a new scorecard but that did not work. Is there another way?

I want to be able to use result from Scorecard A and Scorecard B in another scorecard, or get the result by another way. Thank you in advance!

For example:

Scorecard A = 10   
Scorecard B = 5

Then

Scorecard C = Scorecard A / Scorecard B = 2

Upvotes: -1

Views: 1589

Answers (1)

Bobbylank
Bobbylank

Reputation: 1946

You need to edit your dataset (either through the menus or by clicking the little pencil next to the dataset name in you scorecards).

When the dataset menu comes up, click "ADD A FIELD".

Then you can create a metric which represents scorecard A divided by scorecard B.

So if scorecard A is the sum of metric1 filtered by DimensionX and scorecard B is the sum of metric2 filtered by DimensionY it would be:

sum(case when DimensionX = "Filter value" then metric1 else 0 end)/sum(case when DimensionY = "Another filter value" then metric2 else 0 end)

The metrics need to be ones that haven't already been aggregated.

Upvotes: -1

Related Questions