Referencing another Score Card value in a Calculated Field

Data Studio Data Studio Q&A
1

Hi all,

I have a simple sheet that shows Total Users, Conversion 1, Conversion 2 in score cards.

I’ve auto blended (select Conversion 1, Conversion 2, right click > Blend) the two conversion types, to give a total conversion count.

I’d now like to divide that total by the Total Users to give an overall conversion rate %.

Looking at how the Calculated Field for the autoblend has been done, it’s simplu

sum(conversion1) + sum(conversion2)

with the two Score Card names highlighted in green, which I guess means its actually found those two variables / scorecards.

However, when I try to expend that…

((sum(conversion1) + sum(conversion2)) / sum(Total users))*100

quite apart from any syntax errors (its not got that far yet) it doesnt highlight “Total users” in green, and it gives an error along the lines of “Expected but found “users””.

For some reason, it cant find the variable / score card name, Total users, which is literally the name of the field used in the score card?

2

Hi @cy80rg , thanks for your post!

You can only reference calculated fields that were created in the data source in other calculated fields, and unfortunately, you can’t use a data source calculated field with blended data sources (unless I’m misunderstanding about how you are blending?).

You also can’t reference other chart-specific calculated fields in your formula, even if those fields are defined in the same chart.

If you aren’t blending data sources, you can try creating the first calculated field, Total Users, on the data source.