AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.5K members online now
4.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Date Range based on dates present in the dataset?

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

My data source is the company SQL databases that I cannot connect directly to Google Datastudio, so once or twice a week I export the data I need into a Google Spreadsheet that is connected to DS. I have a widget in which I want to show the total transactions in the last 7 days, compared to the 7 days before that, but since often the 7 days I have in the report are not the same as the 7 last current calendar days I would like to have DataStudio only reflect the days for which I do have the data (so basically taking the last 7 days on the report, not on the calendar).

 

Is there anyway to do this?

 

Thanks!