Data Studio
5K members online now
5K members online now
Ask questions about Data Studio
Guide Me

Date range controls for Google Sheet data source

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi there,


I'm trying to apply the date range settings in a monthly report, to data being pulled in from a data sheet. While charts and tables change to show data within the new range, data from the Sheet doesn't. Also, I can't seem to get my Sheet data to display in any other form other than the aggregation being 'Sum' - so I see the cumulative totals as opposed to the latest month's data.


The data is a combination of numbers and percentages, by month. E.g.:


Column 1: Date (using YYYYMM format as per Google guidelines)

Column 2: List of figures by month, with a column header

Column 3: List of % by month, with a column header


I'm trying to get the data to display using Scorecards, just showing the latest month's figure (in line the date range on the report).


Hope that makes sense!


I think I'm missing something in the Filters within Google Data Studio and/or date range set up in the Sheet - but struggling to find out what exactly is causing the issue.


Thanks for any help you can give.