3 Replies Latest reply on Dec 7, 2017 1:30 PM by Alec Chen

    Dynamic Parameter Values based on Dimension

    Alec Chen

      Hi, I am sure this question has been answered sometime, somewhere before, but I'm not sure if my situation is any different.

       

      I am using parameters to specific a specific date range, and utilizing a "Today" option to display the end date. I took the following steps:

       

      Create parameter.End Date

      Data type: Date/Time

      List of Values, Add from Field [Transaction Date]

      Change Data type to String

       

      Create calculated formula for

      if "Today" then today()

       

      Now the issue with the parameter is that the list of values of Transaction Dates does not update with each refresh. It will be stuck on the most recent day from which the list was added from the [Transaction Date] field. Is there any work around for this?