2 Replies Latest reply on Feb 29, 2016 1:47 PM by pooja.gandhi

    How to automatically show past weeks data only

    Eric Horio



      I'm trying to build a calculation where the workbook and/or dashboard only shows the data for the past weeks. I have the week's set up with a saturday end date. Now I would only like to see the past weeks, not any current or future dates.Is there a calculation where I can only see the data for Feb 20 and Feb 27, but not show Mar 5 yet? Since week ending - Mar 5 data is still coming in/changing on a daily basis, I would like to hide it, so managers don't get confused. I do want the Mar 5 data to be available, but not until Mar 5  I would like to have this done automatically instead of manually changing the filters every week, since this report is on the server. Any suggestions?