1 Reply Latest reply on Jun 15, 2016 12:11 PM by Tom W

    Creating multiple time filters or parameters

    Robert Murphy

      I'd like to create multiple custom time filters or parameters for my worksheet for the following periods:

       

      Last Twelve Months

      Last Three Months

      Year-to-date

      Last Year

      Last 3 Years

       

      Is this a filter or parameter?  This will apply to a transaction data set.  Thanks for your help!

        • 1. Re: Creating multiple time filters or parameters
          Tom W

          Create a list parameter with your options, then create a calculated field you use as a filter which reads the parameter value and constructs a filter accordingly.

          I.e.

          IF [myparameter] = "Last 3 years" and [Sale Date] >= dateadd('year',-3,[Sale Date]) and [Sale Date] <= today() then 'Include'

          ELSEIF [myparameter] .......

          ELSEIF ...........

          ELSE 'Exclude'

          END

          Complete your logic, drag the calculated field onto the filter and set it to 'Include'