1 Reply Latest reply on Mar 14, 2017 2:49 PM by Jay Morehart

    Automatically set a parameter to the maximum date value

    Ryan Krawchuk

      Ok, this issue is a little complicated.

      I am working on creating a Scorecard for our call centre agents that will show the past 12 months worth of data. I currently have the maximum date set in a parameter as the users need to be able to modify the end date so that they can look at their scorecard from a year ago, or whichever date range they want.

       

      So the big question... is there a way to programatically set the initial date on a parameter when the workbook is opened?  This would then allow the user to change the date but would force the user to view the most recent scorecard fist.

       

      As the data is private, I can only provide screenshot.  Please see below.