1 Reply Latest reply on May 22, 2013 11:28 AM by Tracy Rodgers

    Default values in Filter

    philip ken

      Hi All,

      How to set up default current year and current month in Filters so that it will dynamically change? I meant when I open the dashboard Today (which is 2013, May),Year and Month filter supposed to be display 2013 and May. If I open the dashboard in July 2013, Filters values supposed to be show July and 2013... and so on..

      Is this Possible?

        • 1. Re: Default values in Filter
          Tracy Rodgers

          Hi Philip,


          One option would be to create a calculated field similar to the following:


          datepart("month", [Order Date])=datepart('month', today()) and datepart("year", [Order Date])=datepart('year', today())


          Then, place it on the filter shelf and select True. Then, show your quick filter for the Month Year of your date field and select Only Relevant Values.


          Another option would be to use a Relative Date filter and select to show This Month.


          Hope this helps!