How to Report Data by Week, Month, or Other Date Range Besides Day

How to Report Data by Week, Month, or Other Date Range Besides Day

Looker Studio has built-in settings for the Date field that allow you to quickly adjust the data granularity from "Date" to "Year Month", "Month", "Week" and other options.

To adjust the date field's granularity, edit the Date field:



Then select Granularity:



Select a date granularity from the menu:



    • Related Articles

    • Show Sends by Day on a Mailchimp report

      An update to Looker Studio finally allows our customers to create this long-awaited chart. This demonstration will show Automation Campaigns. However, it will also work with Standard Campaigns. Begin at your Automation Campaigns chart on your ...

    • What to Do When a Report Is Loading Slowly

      We understand how frustrating it is when you take time to build a report and it is loading very slowly or timing out. This article will help you with some troubleshooting steps you can use to get your reports loading quickly again. Looker Studio Use ...

    • Some Fields in My Report Say “No Data."

      This article will help to solve the following error in Looker Studio: Cause Looker Studio reports may display "No data" when there is data missing from the data warehouse. Resolution Check the date range specified on the report. Select a date range ...

    • Missing Data in Google Sheets Report

      This article will assist with the following issue: A Google Sheets report is missing data or does not show enough data for a date range. Cause Power My Analytics' Google Sheets connector defaults to a 1,000 row limit. Solution Check the sidebar under ...

    • ActiveCampaign Data Connector User Guide

      Get valuable insights into your email marketing, automation, and sales performance by connecting your ActiveCampaign account to Power My Analytics. This guide will walk you through setup, reporting capabilities, and important considerations. ...