Google Data Studio - Data Blending & Calculated Fields | Data Analytics | Railsware Academy

This is a Google Data Studio tutorial about blending data and calculated fields.

In this video, we describe how to create charts based on multiple data sources and how to create custom calculated fields using function calls and CASE statement. Discover Google Data Studio with us!
0:17 - Data flow description
0:28 - Data Blending in Google Data Studio
1:12 - Adding a new data source
2:50 - Adding a data view to combine 2+ data sources
5:35 - Calculated fields in Google Data Studio
5:56 - WEEKDAY() function in Data Studio
7:45 - Using CASE, WHEN, THEN in calculated fields

Data Studio provides you with enormous opportunities to visualize your data. You can easily build tables, charts, and apply various filters to modify reports.

✅ Subscribe to Railsware and learn the most efficient product management tools with us!

[mdoute]

Thank you for the video, but I have another question. If I have two websites, website A and website B, how can I create one table with the avg bounce rate by Default Channel Grouping for each site? I have two tables set up, one for Website A with Default Channel Grouping as the dimension, and Bounce rate as the metric. I have the same set up for Website B. But when I blend the two, I end up with two columns for Bounce Rate. How can I get the Bounce Rates to appear as an average of Website A and B's data, in a single column?

[jesse]

Thanks for this tutorial! I have a single Google Sheet with multiple tabs which have data for each month, and all the field names are identical. Would I use blended data to have them all together?

[findthetruth]

Wow I love your videos. Please make another video on how to create a map based on latitude and longitude to show all of the data as a point or custom icon. Thnx in advance.

[FANISITE]

I am facing issue in data blending.
I wanna make a YTD sales Dashboard.
I have one google sheet which has 2021 dealer wise sales entries, and 2nd google sheet of current year sales which is on going.
Now the problem is dashboard shows only sales record against existing dealer of 2021, if new dealer came in 2022 sales, dashboard skip its sales.
My both sheets has following Column:
Date, Dealer Name, Area, sales Qty

[usmansarwar]

Hello Sir, I've a data of multiple countries with client names. Client names repeat but with small differences may be someone ads his name with a double space or a comma the second time he adds his data. So I want to blend this data and remove these duplicates. Is it possible to do it by the blended data tables? and Sum the quantity each unique client bought. Actually I want to create Alias

[jnibur]

Interesting video...How do create a calculated field that accumulate numbers. For example how much you spend up to date...Day 1 you spend 100, but day 2, you spend 50...the accumulated would be 150 on day 2, ....

[yadhukrishnan]

Hi I want to create a calculated field for article likes, i tried a CASE function with CASE WHEN EventLabel = "like this article" THEN Total events. But I am getting "cannot mix aggregate and non aggregate measures "error. Can you please help me with any possible alternative solution?

Thanks in advance

[janniemuller]

I have two fact tables (data sources), factACTUAL and factBUDGET, and two dimension tables, dimCOA and dimDate. I can link/blend one of the two dimension tables to both fact tables, but I can only link the second dimension table to one of the two fact tables.
Has anyone overcome this problem before?

[poojarajendranc]

Hi sergey.. I am a beginner in google data studio.. Is there any way you can help me clear some doubts? Thanks in advance