Fast data blending in Looker Studio – Lifehack

Today I am going to show you the trick in Looker Studio that lets you run a successful data blending in a minute!

Here is the video, if you prefer this format:

I’ve prepared three charts beforehand – the dimensions are the same in all of them, but the metrics are somehow different. In the first chart the metric is All users, in the second one – Paid users and in the third one – Display users.

All you need to do to blend all these three charts is to select them, click the right mouse button and then click “Blend”. Then we get a separate table with the blended data and then we can change the type of the element from the table to a bar chart, for example. Now we can compare at the same time all the metrics we had in different charts! 

I think that it is very easy to use and really useful to save more time doing routine tasks! Hope you liked this data blending lifehack!
If you want to learn how to work in Looker Studio, create stunning reports for your own use and for selling – I am here to invite you to my Data Visualization in Looker Studio course! You can read more about it by the link.

Here is the link to my recent article that may interest you! Also, you can check out my Medium blog.