Not able to view option to "Add new field" under blended data!!

Looker Q&A Looker Studio
,
1

I noticed there’s no option to add a new field under blended data, although it is available for a single data source. I’m not sure why this is happening.

Can anyone help??

umairkarel_0-1725710589550.png
umairkarel_0-1725710589550.png305×187 6.01 KB

1 Like
2

@umairkarel

You can add a field in the tables of a data blending (inside the blending configuration) but not directly at the top level of it. So unfortunately, you need to create it only at the chart level contrary to a data source.

Mehdi

3

Thanks @Mehdi_Oudjida

What I want to do is sum (aggregate) two similar fields from different data sources. That’s why I blended the data and expected to create a calculated field using those two fields.

Could you please help me understand how to achieve this?

4

@umairkarel

You need to do it in the setup tab of the chart (see the screenshot below) using a formula like SUM(field_from_table_1)+SUM(field_from_table_2)

Mehdi_Oudjida_0-1725727190905.png
Mehdi_Oudjida_0-1725727190905.png632×1062 97 KB

1 Like
5

Thanks a lot! This is working.

However, I have one more question. How can I filter this data based on a dropdown? My data sources are ads data from different platforms. By default, I want to show aggregated values for all the sources. But when selecting a particular or multiple sources, I want to filter the data accordingly. How can this be achieved?

6

@umairkarel

To do so, the easier way would be to include the the filter field in the data blending configuration and use the data blending as the source of the dropdown control.

I suspect that you are trying to union data, and not specially to reconciliate them. Maybe this article can help you.

https://how.withlookerstudio.com/data-sources/20220222-how-to-mimic-union-all-operator-with-google-data-studio-and-combine-sets-of-data/

Mehdi

1 Like
7

Hey @Mehdi_Oudjida ,

Thanks a lot! That article really helped me achieve the expected functionality. However, I still notice that the dropdown filter is not working. I need to filter by campaigns, but when I add a new field using COALESCE as suggested in the blog to a dropdown, the filter isn’t working as expected, and the data on the entire dashboard is not changing at all! Can you help?

1 Like
8

I have the same issue with the Coalesce within the filter; it does not work. Did you figure it out @umairkarel

9

@Mehdi_Oudjida I have blended data from looker dashboard and google ads. I want to add calculated fields but I’m not able to even see the option of adding calculated fields for the blend. Any method or approach my which I can do that?