1 Reply Latest reply on Feb 7, 2014 10:18 AM by Aaron Clancy

    How to set a default value for a date parameter?

    Joefer Tingson

      Greetings everyone,

       

      I have a created a date parameter in Tableau Desktop and below are the properties of the date parameter:

       

      1. Data Type = Date

      2. Allowable Values = List

      3. The date list is from one of the date columns of our data

       

      I would like to know if the following questions are possible:

       

      1. How can I make the previous date as the default current value of the date parameter?

      2. How to dynamically refresh the list of values of the date parameter?

       

      Thanks,

       

      Joefer

        • 1. Re: How to set a default value for a date parameter?
          Aaron Clancy

          1.   The only way I know how to do this is through embedding the dashboard and passing in yesterdays date through the URL string.  (Would be nice to not have to do this if Tableau ever enhances parameter functionality)

           

          2.  There isn't really a way outside of scripting an XML hack on the TWB.(Also something that would be nice for Tableau to add)

           

          2.a  For scenarios like this I also embed the viz in a web page.

               I then use an HTML dropdown box that is populated by a query directly to my data source with a select distinct on the field that I need.

           

           

          Hope that helped