
Sparkline is a mini line chart without axis and labels to get more context about the trend of a displayed metric for a specific period or variation series. It is often used in data visualization through tables displaying metric trends broken down by dimension values, or in combination with indicator scorecards.
This article is about this 2nd case inside Data Studio (formerly known as Looker Studio).
Sparkline should display a metric trend through a line built thanks to several dots, even when you select a single day. The granularity of a variation should also change to get the best insights: If you select a full year as date range, the trend would be more consistent with monthly variations contrary to daily ones.
So, let’s cook a custom configuration to address these particular case and improve the behavior by default of a basic configuration, based only on daily granularity.
Need to refresh this article
I wrote the first version of this article in January 2021. A lot of improvements & features have been released for more than 2 years of Looker/Data Studio life, including data blending engine with join types and CASE statement capabilities for calculated fields.
In the other hand, Data Studio was also rebranded to Looker Studio and Google Analytics Universal is no longer the norm, 2 months before its sunset, even as a data set for a viz tutorial: Even worse, it could be confusing now with GA4, and their unavailable fields through the direct native Data Studio connector.
At last, Google Cloud team has just released new improvements about scorecard chart type, including sparklines 😃.
So yes, there are a lot of reasons to update this article about adaptative sparkline for reports & dashboard with dynamic date range.
Unlock free access to the full article
Access to this article written by Mehdi Oudjida, Data Studio Expert, is completely free: enter your email address to receive an access link to the full article.
Your email address is only used to send the link, and for the newsletter if you tick the box. It is not stored on this site.



