13.4. How to Filter Blended Data Sources - Advanced Looker Studio Tutorial - Data Studio Course
ฝัง
- เผยแพร่เมื่อ 10 ก.ย. 2024
- Filtering Blended Data: When working with blended data sources in Looker Studio, it's important to understand how filters work with them. Filters are applied to individual data sources first and then to the blended data.
Looker Studio Certification:
When you're ready, take the final exam to test your knowledge and become a certified Looker Studio Expert →
lookerstudioma...
📩 lookerstudio.tips → Receive my weekly Looker Studio tips.
💬 lookerstudio.co... → Get help with Looker Studio.
🔔 Subscribe and turn on notifications so you don't miss the future lessons!
Here's a summary of the key points:
1. When you apply a filter to a blended data source, the filter is applied to the raw tables (data sources) that are part of the blend.
2. The filtered results of the individual data sources are then combined according to the blend configuration.
3. If you have multiple data sources in a blend, filters may affect some data sources but not others, depending on the fields used in the filter.
Example
Let's consider an example with two data sources: Google Analytics and Google Sheets. You have a control for each data source based on the "Country" field. You also have a blended data source created by joining the two data sources on the "Country" field.
When you filter by "Country" for the Google Analytics data source, the following happens:
1. The filter is applied to the Google Analytics data source, showing only the selected country.
2. The blended data source is updated to reflect the filtered Google Analytics data.
3. The filtered Google Analytics data is joined with the Google Sheets data source based on the "Country" field.
When you filter by "Country" for the Google Sheets data source, the following happens:
1. The filter is applied to the Google Sheets data source, showing only the selected country.
2. The blended data source is updated to reflect the filtered Google Sheets data.
3. The filtered Google Sheets data is joined with the unfiltered Google Analytics data source based on the "Country" field.
In both cases, the filters are applied to the individual data sources first, and then the blended data source is updated accordingly.
When working with blended data sources, remember that filters are applied to each data source first and then to the blended data. This can impact your results, so it's essential to understand how the filters are affecting each data source in the blend.
Here's my like, good sir, because you just solve a problem I had been trying to solve for a week. TANK YOU. Saludos desde Venezuela
Love so much your video, thank you for your work! You always cover deep questions, in contrast of other youtubers that cover superficial points. 💚
Thanks for your feedback!
is it possible to filter the blended table, and exclude null values?
Hi Ahmad! How can we configure a filter like that, but in a full join blend with a calculated field? For example, the Ad Platform in the 2 sources of the blend are "Google Ads" and "Facebook Ads". I am trying to put a dropdown list filter but does not work. Thank you!
Good morning Mr Ahmed, I have a blended data and I want to filter by 4 controls: Date, Mode, Destination and transporter , knowing that all these are fields in the two tables blended. The join is full outer join. Thanks in advance
Great videos. Trying to find solution for something like this hypothetical example: data src 1: home id, sales price. data src 2: home id, cost-to-build. Doing blended table with calc field for ROI… sales price - cost to build, but noticing I can’t apply filter on ROI in blended table… for example. Would like to filter blended table by home id with ROI >= to 50k. Basically not seeing where you can filter blended table by calculated field. Or not seeing way to filter using logic that looks at both data sets. Ie… data src 2 sales price - data sec 1 cost >= 50k. Sound like this could be related to any of your other filter tutorials?
So does it mean it's not possible to set a control for filtering blended data source? That's too bad! I wanted to create an interactive cross filtering table, which one source is a blended data.
Has this been fixed or somthing. Because i ahve done the bridge filters but it still doesnt filter only filter one table
It should still work. A filter control filters all components that are connected to a data source that has a field with the same ID as the field applied to the filter control.
Hi Ahmad. Thanks for the video. Quick question. What would you do if you wanted to filter the blended data (bottom control) for the condition where Revenue > Ad Cost?
Try creating a custom field at the blended data source level to check if Revenue > Ad Cost (simply enter this a formula) and it returns either true or false. Then you should be able to filter the blended data source based on this boolean field.