Data Studio
4K members online now
4K 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!