--- title: "Multiple Date Ranges, One Looker Studio Table: A How-To Guide" description: A step-by-step guide for how to create a table with multiple date ranges to keep your Google Data Studio/Looker Studio dashboard clean and organized. image: https://blog.dataddo.com/hubfs/multiple-data-ranges-min.jpg --- [![Dataddo Blog](https://blog.dataddo.com/hs-fs/hubfs/blog-logo.png?width=180&name=blog-logo.png)](https://blog.dataddo.com) ** [Get Dataddo Free](https://www.dataddo.com/signup?hsLang=en) [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9) # Multiple Date Ranges, One Looker Studio Table: A How-To Guide By Jakub Plas | 6 min read ![](https://blog.dataddo.com/hubfs/multiple-data-ranges-min.jpg) - ** - ** - ** I don’t have to tell you that [Looker Studio](https://cloud.google.com/looker-studio) is a very powerful tool. But you've probably found that there are some things you just can't do well, or easily, in Looker Studio.  **Example: Having multiple date ranges in the columns of a single table. ** The easy way out is to create a table for each date range. But then you end up having a mess of tables in your dashboard that is in no way as pretty and easy to read as it should be.  So, what’s a solution that’s easy to implement and will also maintain the integrity (and aesthetics) of your dashboard?  The answer is data blending. --- **Want more Looker Studio tips & tricks?** [**Find out how to track your Instagram follower count in Looker Studio.**](https://blog.dataddo.com/how-to-track-your-instagram-follower-count?hsLang=en) ---   ## How to Blend Data in Looker Studio For this example, let’s say I want to view my sales numbers per week. So, I want to create a table with: - the names of my products, - a dynamic date range, - and the number of sales. With this simple data set, your table will probably look something like this: ![Product & Sales Table-before](https://blog.dataddo.com/hs-fs/hubfs/1-table-before-png.png?width=371&name=1-table-before-png.png) But, I want to see something like this: **![Product & Sales Table after transformation](https://lh3.googleusercontent.com/ZuHxWNwivaDgxFKJclZzHuOF0qd6cnZhgj8AesxGeCEQL2W05bz71MeyASD_j7TLLBgPG7gx5ksEPx931hQA1AW3qkSsipb9o_xfORX8uWsudNoIikE245JhNHGTvgiKX3rZ5GUH)** --- Get your data to Looker Studio, ABSOLUTELY FREE, with [Dataddo's Free forever plan](https://dataddo.com/products/data-to-dashboards).  --- ## Here’s where the blending comes in. 1. With your table selected, click on ‘Blend Data’ under the Data tab. ![Step 1: Blend data in Data Studio](https://blog.dataddo.com/hs-fs/hubfs/Step%201-GDS-blend%20data-png-1.png?width=279&name=Step%201-GDS-blend%20data-png-1.png) 2. Now, you’ll select your dimensions, metrics, and date range. In this example, I want my dimensions to be “line_item_item_name”, the metrics to be “line_item_quantity”, and my date range to be “receipt_date”. **![Step 2: Select dimensions, metrics, and date range](https://blog.dataddo.com/hs-fs/hubfs/Step%202-GDS-dimensions-metrics-date-png.png?width=557&name=Step%202-GDS-dimensions-metrics-date-png.png)** 3. The date range will be set to ‘Auto’ by default (as seen in the above image). But we’re going to select ‘Custom’  and then select ‘Last 7 Days’. Doing this will make the date range dynamic, meaning the data will update to show data from the last seven days, not a specific date.**![Step 3: Create a dynamic date range in Data Studio](https://blog.dataddo.com/hs-fs/hubfs/Step%203-GDS-date-gif.gif?width=590&name=Step%203-GDS-date-gif.gif)***Note:** If you don’t need a dynamic date range, you can select the specific dates you would like to look at in this step.* 4. Now, click ‘Add Another Source’ and select the same data set as previously.  5. Under ‘Join Keys’, we will select “line_item_variant_id”. These are unique numbers associated with each product in my store, such as a SKU. The join key will match data from both sets based on our selected key - the product ID. ![Step 5-GDS-join-keys](https://blog.dataddo.com/hs-fs/hubfs/Step%205-GDS-join-keys.png?width=369&name=Step%205-GDS-join-keys.png) ***Note:** A join key must be a unique identifier that is present in every data set you are blending (in this case, we’re using the same data set). Other common join keys might be customer ID, email address, or receipt number. * 6. Next, you’ll input the same dimensions and metrics as in step 2. Dimensions will be “line_item_item_name”, metrics set to “line_item_quantity”, and date range will be “receipt_date”. 7. The date range will be set to ‘Auto’ again and we will go through the same process of selecting ‘Custom’. But this time, we will set the calendar pop-up to ‘Advanced’ in the top right corner (the very last option). This will allow us to create a new dynamic date range. Set the start date to today’s date and the end date to one week from now. Set to ‘minus’ for both dates and then input ‘14’ under today’s date and ‘8’ under the other date. This will create a date range of 8-14 days ago. Then click ‘Apply’. ![Step 7: Dynamic date range in GDS](https://blog.dataddo.com/hs-fs/hubfs/Step%207-GDS-date-range-gif.gif?width=600&name=Step%207-GDS-date-range-gif.gif)***Pro Tip:** Use custom names for your ****metric fields**** to describe which date range the metric is coming from to make your newly blended data sets easier to understand. I’ve named my new field ‘8-14’ to signify the data is based on sales numbers from 8-14 days ago.* ![Step 7 Tip: Use custom names for your metric fields](https://blog.dataddo.com/hs-fs/hubfs/Step%207-Tip-GDS-metric-fields-gif-1.gif?width=600&name=Step%207-Tip-GDS-metric-fields-gif-1.gif) 8. Repeat steps 4-7 to add more date range columns to your table. ***Note:** Looker Studio only allows up to five data sources to be blended in one table. * 9. Once you have all of our sources connected, name your new source, save it, and you can create your table! Your table will now pull data from the different date ranges of the data set you have blended so you can view your metrics from multiple date ranges all in one place.  ## Having Trouble Getting Data into Looker Studio? If you’re spending hours on manually extracting data from your data sources to be imported into Looker Studio, you’re wasting your time! With a no-code data integration platform like [Dataddo](http://dataddo.com), you can get your data automatically updated in [Looker Studio ](https://www.dataddo.com/app/google-data-studio?hsLang=en)(or any [destination](https://www.dataddo.com/connectors?hsLang=en)) so you’re always looking at the most up-to-date info.  With more than 150 out-of-the-box [data sources](https://www.dataddo.com/connectors?hsLang=en#sources) available, you’re sure to find all the connections you need. Still can’t find the source you’re looking for? Contact the tech team about setting up a customized connector in less than a week. But you don’t have to take our word for it. Try out the platform with a [14-day free trial](https://www.dataddo.com/signup/?hsLang=en), including free onboarding assistance and full platform functionality. Get the most out of your data with the help of Dataddo. |   **See how Dataddo can help your business, FOR FREE** Just a few quick steps to get your data to your dashboard for better analysis, without the hassle, and without the cost. [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a) | | --- | Category: [Industry Insights](https://blog.dataddo.com/tag/industry-insights), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Related Articles** ## [Exposing The Role of Data Pipelines in AI Projects Success](https://blog.dataddo.com/data-pipelines-ai-success?hsLang=en) *(6 min read )* Topics: [Industry Insights](https://blog.dataddo.com/tag/industry-insights), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [The Dataddo Community Forum: A Place for Support, Feedback, Resources](https://blog.dataddo.com/the-dataddo-community-forum-a-place-for-support-feedback-resources?hsLang=en) *(6 min read )* Topics: [Industry Insights](https://blog.dataddo.com/tag/industry-insights), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [Easy Kafka Data Pipelines to Databases and Apps: Real-Time Streaming](https://blog.dataddo.com/easy-kafka-data-pipelines-to-databases-and-apps-real-time-streaming?hsLang=en) *(6 min read )* Topics: [Industry Insights](https://blog.dataddo.com/tag/industry-insights), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Subscribe to The Chronicles of Marketing Newsletter ## Comments ## Subscribe to Our Blog Stay up to date with the latest marketing, sales, and service tips and news. ![subscribe](https://blog.dataddo.com/hubfs/Illustrations/subscribe.svg) - [****](https://www.linkedin.com/company/dataddo) - © Dataddo, Inc. All Rights Reserved ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Jakub Plas", "url" : "https://blog.dataddo.com/author/jakub-plas" }, "dateModified" : "2024-12-09T07:29:16.780Z", "datePublished" : "2021-02-10T15:28:22.000Z", "headline" : "Multiple Date Ranges, One Looker Studio Table: A How-To Guide", "image" : [ "https://blog.dataddo.com/hubfs/multiple-data-ranges-min.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.dataddo.com/multiple-date-ranges-one-data-studio-table-a-how-to-guide", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dataddo.com/hubfs/Dark%20logo@3x-1.png" }, "name" : "Dataddo, Inc." } } ```