Date Range based on dates present in the dataset?[ Edited ]
April 2017 - last edited April 2017
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?