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 ...
Report Data in Power BI
Power My Analytics offers a native Power BI connector that allows you to load your Data Builder datasets directly into Power BI Desktop for custom reports and dashboards. This guide walks you through connecting your PMA hub to Power BI, installing ...
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 ...