Filters

Filters allow you to narrow the scope of your reports by restricting the amount of data using specified criteria. In many cases you may only want to see a subset of rows in a data category, rather than its entirety.

For example, imagine a category containing a row for every single sale your company has ever made. You may only want to see sales from the past month. You can accomplish this by using a filter to limit the amount of data to receive. This also has the benefit of speeding up your reports.

The report wizard uses filters which limit data by checking data values against a condition. These are called Standard filters.

Adding filters

On the Filters page, add data field filters. For each data field, you need to select a condition. When the report is run, the data field value for each row is checked against the condition for that data field. Only the rows where the field satisfies the condition will show on the report.

To create a filter condition:

  1. Select an operator from one of the following options. This is the condition used to match the data values to your specified filter value or values. Some operators are only available for some data types.

    For the available operators, the data satisfies the condition if the data value:

    Equal To

    Is equal to the filter value

    Less Than

    Less Than Or Equal To

    Greater Than

    Greater Than Or Equal To

    Not Equal To

    Is not equal to the filter value

    Starts With

    Not Starts With

    Ends With

    Not Ends With

    Contains

    Not Contains

    Between

    Is between the two filter values

    Not Between

    Is not between the two filter values

    One Of

    Is equal to any one of the filter values

    Not One Of

    Is not equal to any of the filter values

  2. Enter a filter value or values, or select them from the list.

  3. Optional: If you have multiple filters, you can choose how they should be grouped. See Grouping filters together.

  4. Optional: If you want the report to prompt the user to enter a filter value when the report is run, select Prompt For Value. See below for details.

Prompting for values

If you want to let users select their own filter values when they run the report, you can set filters to Prompt For Value. In the Report Options, you can choose whether to let users change the operators and delete filters.

You do not need to enter a value for prompting filters. But if you do, it is entered as the default value for the filter in the prompt dialog.

Values for prompting filters can be overridden by Dashboards, Chained Reports, and Schedules.

Grouping filters together

When a data row is checked against the report filters, the values for each of its data fields are checked against all of the filters for the data fields. By default, it must satisfy every filter condition to show on the report. The combined statement used to filter the data rows is shown in the Summary field.

You can specify that a data row needs only to satisfy one filter, or a selection of filters, to show on the report.

To specify that a data row needs to satisfy any one of several filters:

  1. On the Filters page, drag the filter rows next to each other.

  2. Select the first filter.

  3. Select OR With Next Filter.

    You should notice that in the Summary field, the And between this filter and the next has changed to Or.

  4. Repeat steps 2-3 for every filter except the last.

You can group filters together, to specify that a data row can match either one group of filters, or another group of filters, to show on the report.

To specify that a data row needs to satisfy any one of several groups of filters:

  1. On the Filters page, drag the filter rows such that the filters are nearest to their group mates.

  2. Select the first filter in the first group.

  3. Select Group With Next Filter.

    You should notice that in the Summary field, there are now parentheses around this filter and the next.

  4. Repeat steps 2-3 for every filter except the last in the first group.

  5. Select the last filter in the first group.

  6. Select OR With Next Filter.

    You should notice that in the Summary field, the And between this filter and the next has changed to Or.

  7. Repeat steps 2-6 for every group of filters. Skip step 6 for the last filter in the last group.

Nesting filter groups (for advanced users)

Filter groups can be nested arbitrarily. This allows for more detailed control over grouping. The Summary field shows the actual statement used to filter the data. You can make arbitrary groupings by inserting parentheses manually at locations in the statement. Use the following keyboard shortcuts:

Troubleshooting

If there are data fields from the Categories page that are missing from the Filters page, the data field may be unfilterable. Contact your administrator.