1 Reply Latest reply on Apr 22, 2014 11:58 AM by Lucas Brito

    default parameter to today's date

    Saken Kulkarni

      Hi Tableau jedis,

       

      I have a quick question. I have a date field that I am using as a parameter. I want that date field to default to today's date each time I log in. e.g. if today is April 22nd and the user comes in tomorrow (april 23rd) I want the date field to default to April 23rd.

       

      Any idea how to do this?

        • 1. Re: default parameter to today's date
          Lucas Brito

          Saken,

           

          I am not sure this will work for what you intend to do, but this is how i would try to solve it.

          Create a calculated field to store today's date.. Today()

          Then create a parameter, and reference your calculated field under the value list.

          List -> Add from Field -> Calculated Field.

          After you are done, do the same steps but this time to add the other date field that you having containing the previous dates... This way, the first value in the view should be today's date, but you would still be able to leverage the historical data imported from the other field.

           

          Let me know if that works.