Data Blends: A Metric has different name in each Source

[_Daniela]

Hi Community!

I'm having some issues while working with Blends when trying to report the total spent of different platforms in one single chart since this metric has a different name depending on the source, therefore the join operator does not work, and I'm not being successful with the functions. Is there a way to unify the spent in just one column?

Thank you

[Mehdi_Oudjida]

@_Daniela 

This tutorial can help you.

https://how.withlookerstudio.com/data-sources/20220222-how-to-mimic-union-all-operator-with-google-d...

For your use case, you could also just create a calculated field at the chart level with the sum of each spent metric: SUM(Cost)+SUM(Amont spent)+SUM(Revenue...

I hope it helps.

Mehdi