Check out all the tutorials of the blog here! There are various of them about Looker Studio and Google Sheets. Formulas, report creation, tricks & tips – everything is in this section.
Do you know that you can (and should!) write custom formulas inside pivot tables in Google Sheets? Calculated fields is, actually, one of my favorite topics, I’ve written a couple of articles about it. By this link you can read …
Correct ROAS calculation in Google Sheets pivot tables Read more »
When you create a weekly report in Looker Studio you can use the ISO Week field type. But it is super long and often you can’t see the full week’s name. Keep up with the article to see how to …
Looker Studio Calculated Fields. Extracting week from date Read more »
If you work in the area of data visualization in Looker Studio, for sure you have to work in Google Sheets to prepare your data. Today I would like to share a case with the REGEXMATCH Google Sheets formula. Task …
Google Sheets is a great tool that I use everyday in my work and as we all know it has plenty of formulas that easen our routine tasks and one of the formulas that I find really interesting and useful …
When working with interrelated data, one of the foremost common challenges is finding data over different sheets. You frequently perform such tasks in everyday life, for example when checking a flight plan board for your flight number to induce the …
How to use the VLOOKUP function in Google Sheets? Read more »
Have you ever faced an issue while working in Google Sheets when you need to convert cost or revenue from one currency to another? It is much easier than you may think because Google Sheets has a special function for …
How to convert currency in Google Sheets by a specific date using Googlefinance formula? Read more »
Customizing the navigation menu of your dashboard in Looker Studio can help you better organize your reports and make it easier for users to find the information they need. Here are some steps to help you get started. Here is …
How to customize the navigation menu of your dashboard in Looker Studio Read more »
Google Sheets is a powerful spreadsheet software that allows you to perform a variety of data analysis tasks. One common task is extracting the month from a date. This can be useful if you need to group data by month …
How to extract month from date in Google Sheets – Tutorial Read more »
The correctly made report consists of the header, body and the footer. You may have many pages in your report, and recreating headers and footers on every page must be tiring and taking a lot of time! In this Looker …
Page- and report-level elements in Looker Studio – Tutorial Read more »
If you have ever tried working in Looker Studio, you surely have to know how long it takes to set up all the tables and elements to be in the same style. In this Looker Studio tutorial I am going …
How to copy element styles in Looker Studio – Tutorial Read more »
0 items in the cart (0 €)