6 Replies Latest reply on Jun 2, 2015 10:40 PM by Annie Lum

    Use Week quick filter in a calculated field?

    Annie Lum

      Hi,

       

      I'm creating a dashboard which changes based on the week end date selected.  The week end date is a quick filter on the dashboard.  Most of the charts on the dashboard are time series charts based on the week end date Start and End dates selected.  Eg. 11/1/2014 - 25/4/2015 will show a chart for data between these dates.  However, on the dashboard I also want to show the total records for the last week which is 25/4/2015 in this case.  Can I pass this date somehow to a calculated field, or do I need to set up parameters for the start and end dates to make this work?

       

      Thank you!

       

      Annie