Skip to content

Do you struggle to compare different date ranges in your data analysis? Comparing two different date ranges is a great way to gain insights into your business and identify trends over time.

In this tutorial, we’ll show you how to compare two different date ranges in tables in Looker Studio, and explain why it’s an essential skill for any data analyst or business professional.

Header Outline:

I. Introduction
II. Comparing Two Different Date Ranges in Tables in Looker Studio
A. Accessing the Report
B. Adding the Table & Date Range Control
C. Copying the Table & Date Range Control
D. Grouping the Information
E. Setting the Date Range Comparison
III. Best Practices for Comparing Two Different Date Ranges in Tables in Looker Studio
IV. Conclusion

I. Introduction

Looker Studio is a powerful data visualisation tool that allows you to easily analyse your data. One of the key features of Looker Studio is the ability to compare two different date ranges in tables.

By comparing two different date ranges in a table, you can quickly analyse your data and gain valuable insights into your business metrics. In this post, we will guide you through the process of comparing two different date ranges in tables in Looker Studio.

II. Comparing Two Different Date Ranges in Tables in Looker Studio

To compare two different date ranges in tables in Looker Studio, follow these steps:

A. Accessing the Report

  1. Log in to your Looker Studio account.
  2. Access the report that you want to compare two different date ranges in a table for.

B. Adding the Table & Date Range Control

  1. Click on the “Add a chart” button.
  2. Select the “Table” option.
  3. Select the data source and the fields that you want to include in the table.
  4. Click on “Add a Control” button and add a Date Range Control.

C. Copying the Table & Date Range Control

  1. Select both the Table and Date Range Control.
  2. Select “Editing’ and then select “Copy”.
  3. Select “Editing” again and then select “Paste”.
  4. Move the pasted Table & Date Range Control to your desired position on canvas.

D. Grouping the Information

  1. Select the first Table and Date Range Control on the left.
  2. Select “Arrange” and then “Group” (if not already grouped).
  3. Select the second Table and Date Range Control on the right.
  4. Select “Arrange” and then “Group” (if not already grouped).

E. Setting the Date Range Comparison

  1. Click on the Date Range Control on the left.
  2. Select the date range that you want for Period 1
  3. Click on the Date Range Control on the right.
  4. Select the date range you want for Period 2 to compare to Period 1.

III. Best Practices for Comparing Two Different Date Ranges in Tables in Looker Studio

Here are some best practices for comparing two different date ranges in tables in Looker Studio:

  • Use the comparison to identify trends and patterns over time.
  • Consider using calculated fields to perform more complex calculations on your data.

IV. Conclusion

By following the steps outlined in this guide and following best practices, you can quickly compare two different date ranges in tables in Looker Studio.

This simple process will allow you to gain valuable insights into your business metrics and make data-driven decisions. Remember to use the comparison to identify trends and patterns over time and consider using calculated fields for more complex calculations.

Back To Top