Filters are designed to be read, which makes it easier to set the criteria correctly.
To add a filter:
Click Add Filter, And, or Or.
Choose what information you want to see.
Choose from your options:
A down arrow means you can make a choice from a menu.
Type in text boxes.
If you have more choices to make, you are taken to another screen or filter section.
When your filter is finished, keep clicking OK until you are back on the reporting screen.
To check your filters, read the filter descriptions along the top of the screen. Click a filter to see its details or edit it.
Drag filters to move them to a different section.
Filter on Other Types of Information
You can include filters that look for specific information about another type of data. For example, you are creating a constituent report. You want to find constituents with vacation addresses in Maine.
Click Add Filter.
Click Has Addresses.
Click Addresses and click Specific Addresses.
In the Address Filters and Include section, click Add Filter.
Click State.
Enter or select Maine from the menu.
Click OK.
Next to State is Maine, click And.
Click Type.
Enter or select Vacation from the menu.
Figure 1: Cross-data filters after step 10.
Keep clicking OK until you are back on the main report screen.
Filter on Comparisons
Set filters to compare one set of criteria to another. You can compare numbers or transactions.
Compare to Numbers
The Between criterion compares numbers. The following tables shows how to set up comparisons using the number 5:
Comparison | Type numbers in the Zero and Infinity fields |
At least | |
At most | |
Equals | |
Any number |
Compare Transactions
When you are looking for constituents with specific transaction information, set up comparison transaction filters. Figure 2 shows comparing to a value, and Figure 3 shows comparing calculated values.
Click Add Filter.
Click Has Transactions.
Click Has Any and then The Calculated.
Fill in other comparison information. If you select Specific Transactions, set your filters.
Click OK until you are back on the main report screen.
Figure 2: Compare pledge averages to $1000
Figure 3: Compare this year's giving to last year's giving
Filter for Empty Values
Fields that aren't required may not be filled out during data entry. This is especially true of custom fields. For example, you want to find transactions that do not have an appeal. To find these empty fields:
Click Add Filter.
Click Appeal.
Click Is and then Is Empty.
Click OK until you get back to the main report screen.