Access: Account Settings > Reports > (Add or Edit a Report) > Filters
Report Filters enable you to restrict the amount of data that is returned in a report based on various criteria.
Date Filters
Date Filters are date/time-based intervals used to filter data.
Date Filters restrict the data displayed in the report to records within the specified date ranges.
All date fields are grouped in the select menu for the filter fields, including Date Type custom questions.
To create a Date Filter: Begin with Interval #1. In the first drop-down list, select a report parameter (e.g., Reg Date Created). In the second drop-down list, select a pre-existing date-range to apply to that report parameter (for example, Future, Today, This Month), or select Custom to define your own date range. If you select Custom, enter the Start Date / Start Time and End Date / End Time. Enter dates in MM/DD/YYYY format (or use the calendar) and times in 24-hour format (HH:MM:SS), based on U.S. Pacific Time. You can add a second date filter. By default, Interval #2 begins with AND. You may select OR instead. Select a report parameter and a date range for Interval #2, as you did for Interval #1.
Standard Filters
Standard Filters are pre-designed filters that restrict data to records that match commonly selected parameters.
The Standard Filters available depend on the report type.
Example: A Registrations report includes Standard Registration Filters such as Complete with values Any, Yes, or No.
The default values for all Standard Filters is [Any], meaning "any value."
Selecting [Any] provides the most inclusive results, since no filter is applied.
To utilize Standard Filters: Choose the Standard Filters that match your needs by selecting from the corresponding drop-down list(es).
Drill-Down Filters
Drill-Down Filters enable you to view different subsets of report results while the report is running.
For instance, if a report includes the parameter Registration Status, you might want to see all registrations with status Attended.
Other times you might want to see registrations with status Cancelled.
Using a Drill-Down Filter, you can switch quickly and easily between these two views.
To utilize Drill-Down Filters: From a Drill-Down drop-down list, select the report parameter that has the subset results you want to view. The columns available to use as Drill-Down Filters depend upon the report type. Example: For a Registrations report, the available Drill-Down Filters include Complete, Paid, Registered, Attendee Type, Attendee Type Type, Reg Status, and Status Type. Run the report. The Report Results window opens. From the Drill-Down section on the Report Results page, select the results you want to view. Click the Drill-Down button.
Advanced Filters
Advanced Filters are logic rules with which to filter data.
These Advanced Filters enable you to create highly customized reports.
You may create up to ten Advanced Filters on any report.
You may select numeric values in the advanced filters, but you must use the Date Filters above to filter on date fields.
To create an Advanced Filter: Select the Column that you wish to use to filter data. Select an Operator, specifying how the data field contents will be evaluated; for example, equals (=) or is not equal to (<>). Specify a Value. You can enter an open-ended value in the text box: a text string such as "North Carolina" or "@certain.com." For "Yes", enter the numeral 1; for "No", enter the numeral 0. Or, if shown, click the Pick List icon to see a list of predefined values. If you are using two or more Advanced Filters, select a statement connector from the drop-down list as the logic to join your filters. If you select and between two filters, records will be included only if both conditions are true. If you select or between two filters, records will be included only if one condition is true. The and/or connectors enable you to complete grouping of filters and join groups with a logical and or or.