March 31, 2023
- by Mehdi Oudjida
Le’s have fun with Looker Studio, using Using charts as a drawing engine! Dragon Ball was a cartoon of my childhood. Here a drawing with:
Read more
February 9, 2023
- by Mehdi Oudjida
Let’s go back to the basic to create a simple metric selector. This allows to change the measure displayed inside a set of Looker Studio charts (formerly known as Google Data Studio) as report reader. Taking of avantage of a…
Read more
October 26, 2022
- by Mehdi Oudjida
Few years ago, I wrote a tutorial about how we can include annotations inside Looker Studio line charts. My custom solution was nice for instant events and correlation analysis. This time, we will take care about periods and events occurring…
Read more
October 3, 2022
- by Mehdi Oudjida
Keeping charts as simple as possible is very challenging. For some cases, a single interactive feature can offer a first level of data exploration or calculation without overloading the default state of your Looker Studio (formerly Data Studio) chart. In…
Read more
July 25, 2022
- by Mehdi Oudjida
I always prefer preparing data outside Data Studio and I always prefer using builtin chart types when it is possible. But sometimes, we need something fast, more or less disposable, addressing temporarily visualization needs, to get a first level of…
Read more
June 23, 2022
- by Mehdi Oudjida
Funnel report type inside Looker Studio, a recurring need for a popular visualization. There are a lot of solutions, templates, articles describing how to do. Most of these resources are nice and address the visualisation need. Technically speaking, they are…
Read more
May 11, 2022
- by Mehdi Oudjida
For a lot of cases, legends are not the best visualization solution for line chart (and similar trends chart types). Often, the chart and related data are simple BUT complicated to read because of it requires back and forth to…
Read more
May 3, 2022
- by Mehdi Oudjida
The Looker Studio (ex Google Data Studio) calculated field below returns the older date from a date dimension. The min date in other words.
Read more
May 3, 2022
- by Mehdi Oudjida
The Looker Studio (ex Google Data Studio) calculated field below returns the most recent date from a date dimension. The max date in other words.
Read more
April 22, 2022
- by Mehdi Oudjida
Waterfall charts are nice & efficient to visualize cumulative values of a metric and the related participation weight of each item, towards the final value. In digital analytics fields, it can address insights about frictions on funnels, form filling, web…
Read more
March 25, 2022
- by Mehdi Oudjida
The Looker Studio calculated field below returns the file name with the related extension from a field providing an absolute URL.
Read more
March 9, 2022
- by Mehdi Oudjida
Few months ago, I’ve discovered a nice Google hidden URL thanks to a tweet from Ben Collins about a Google Sheets tip. If you use Sheets, I strongly recommend to follow Ben and enjoy what he shares every day. Thank…
Read more
February 22, 2022
- by Mehdi Oudjida
Last week, we enjoyed discovering the new possibilities of data manipulation inside Looker Studio (formerly known as Google Data Studio), thanks to the new data blending features. Now, it is time for a first tip to leverage them and built…
Read more
February 16, 2022
- by Mehdi Oudjida
The Looker Studio Google Data Studio team has just released a highly anticipated new feature paving the way for a lot of amazing possibilities about data manipulation & preparation: A new data blending engine with join types (inner, outer, right…
Read more
January 23, 2022
- by Mehdi Oudjida
The Looker Studio (ex Google Data Studio) calculated field below extracts the value of a specific query parameter and returns it as a text / string.
Read more
January 11, 2022
- by Mehdi Oudjida
Building a statistics annual report is a nice exercise for challenging the way to display metric values comparison over a granularity of time inside our data visualisation tool. We could decide to use the default available feature of the tool,…
Read more
December 7, 2021
- by Mehdi Oudjida
Need to access to selected date range and related time repository Most of data sources and related APIs provide rows of dated data only if the requested data are available (in other words, when the combination of all requested fields…
Read more
November 5, 2021
- by Mehdi Oudjida
Let’s describe step by step, inside Looker Studio (formerly known as Google Data Studio) – how to split delimiter-separated values – as example with comma – from a text dimension to get the same related metrics, drilled down by real…
Read more
October 7, 2021
- by Mehdi Oudjida
The Google Data Studio team has just released amazing new features about the navigation and pages management of your reports: Report makers get a new experience – as editors – for pages creation & management, smoother than before and saving…
Read more
September 20, 2021
- by Mehdi Oudjida
To fit to columns width in table charts or axis size, truncating long texts at the right – like proposed inside Looker Studio – is not always the best visualisation solution for dimension values. On the other hand, the Looker…
Read more
