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 moreKeeping 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 moreI 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 moreWe create funnel reports for a while inside Google Data Studio. 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 based on…
Read moreFor 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 moreThe Google Data Studio calculated field below returns the older date from a date dimension. The min date in other words. Explanations of the formula step by step Get the older date of the date field using MIN function that…
Read moreThe Google Data Studio calculated field below returns the most recent date from a date dimension. The max date in other words. Explanations of the formula step by step Get the max Date of the date field using MAX function…
Read moreWaterfall 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 moreThe Google Data Studio calculated field below returns the file name with the related extension from a field providing an absolute URL.
Read moreFew 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 moreLast 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 moreThe 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 moreThe Google Data Studio calculated field below extracts the value of a specific query parameter and returns it as a text / string. Input Field corresponding to the URL / Page address with parameters (test / string) Example 1 –…
Read moreBuilding 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 moreNeed 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
