0 Replies Latest reply on Mar 13, 2013 4:38 PM by David Martin

    Date Range - Percent Change

    David Martin

      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.

       

      Thanks!