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:
Still having issues?
Send us a ticket and we will get back to you.
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 ...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 ...How to Create a Report in Data Explorer
Data Explorer is a valuable tool that can be used to create reports for export to BigQuery or FTP , to test out a connection, or even to create a CSV file. This tool is available to all Power My Analytics customers and is included in the cost of your ...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 ...