I have 1 data source that I am building multiple worksheets from and I am would like to know if it is possible to make the Date range Global on only selected worksheets. I'd like to make the date range global because I want the ability to filter/update specific charts, while keeping my trending bar graph stable (not filtered).
Essentially what I am try to do is build a Table with only the most recent week's data while creating a new table that only shows only last week's data. The issue I am running into is having to manually adjust the date ranges. Is there a way to build the dashboard so that these will automatically update to the most recent and last week's data when I refresh my datasheet with new information? And yes, the two charts need to be separate from each other.