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


Data 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 Data 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 Mailchimp ...
    • Data Studio: Grand Total Over a Date Range is Less Than Sum of Individual Rows Broken Out By Date

      This page will assist you with the following issue: When reporting individual values by date in Data Studio, the sum of these individual values over a date range may be less than the grand total of the values over the same date range. For example, ...
    • 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. Data Studio Use a ...
    • Understanding Data Delays

      Some data sources report data with a built-in delay imposed by their platform APIs. This article explains which Power My Analytics connectors are affected, how long each delay lasts, and what it means for your reports. What Is a Data Delay? A data ...
    • CallRail Data Connector User Guide

      CallRail turns your phone calls, texts, and form submissions into marketing data you can report on. With the Power My Analytics CallRail connector, you can pull your call tracking, attribution, and Conversation Intelligence data into your favorite ...