Advanced Options for Function Filters

You may be able to set advanced options that refine the basic formula of a function filter. The availability of each option may depend on the function or attribute you select for the filter.

An Exclude option is common to all conditions. Clear it to get records that satisfy a filter's attribute-condition formula. Select it to exclude those records and get all others.

Other options include:

• Generate Subgroups: This option applies when a function uses groups created by a system-generated object, and typically when the Count function is selected. Clear it to count the number of subgroups that belong to each group. Select it to count either of the following:

  • The number of records in each subgroup, if the attribute in the Filter line is also selected as a result attribute.

  • The number of records in each parent group, if the attribute in the Filter line isn't a result attribute.

• Over Interval: This option applies when a function organizes groups by date. Clear it to have each group contain records generated on a distinct date. Select it to have each group contain records whose dates fall within a time period. You define the period:

  • Specify Overlap to define overlapping periods. For example, two-day periods may include Monday and Tuesday, then Tuesday and Wednesday, then Wednesday and Thursday.

  • Specify Successive to define distinct periods. In the two-day-period example, periods might be Monday and Tuesday, then Wednesday and Thursday, then Friday and Saturday.

  • Having selected Overlap or Successive, select a number of days, weeks, or months, then set start and end dates.

• Display in Descending Order: This option applies to the Rank function. Clear it to rank values in ascending order. Select it to rank values in descending order.