Skip to main content

Create Date Range Filters

Date range filters enable you to show only data that meets the conditions of the filter in a report. For example, you can create filters to display data between 2010 and 2013, or data after 2010.

  1. Log in to the User Console, choose New Analysis. The Select Data Source dialog appears.

  2. Select the data source that you want to use and click OK.

  3. Create an Analyzer report with a time dimension, such as year or quarter.

  4. Right-click the column or row header for the time dimension and choose Filter. The Filter dialog appears.

  5. Choose Select a range.

  6. From the drop-down menus, choose Between (and incl.), After (and incl.), or Before (and incl.) and the dates that you want to appear as a result of filter.

  7. Click OK.

The Analyzer report filters data according to data ranges you specified.

When you create a date range filter using the Between (and incl.) operator and parameterize it, as described in chapter Add Query Parameters to Analyzer Reports , you specify one parameter name, but two parameters are created. One parameter controls the start of the range, and another control the end of the range. The start date parameter is <YourParameterName>_START, and the end date parameter is <YourParameterName>_END.