When you choose a grouping field for a filter, you'll be prompted to choose which type of date filter you want to create:
Single Value gives you a simple dropdown containing the different values found for the grouping. This option is best for a small number of values.
Multi Value gives you a searchable pick list of values. This option works better with a large number of values. You can also connect multi value filters so that the selection in one will limit what's shown in the pick list of another and you can limit the maximum number of selections.
Pattern Match gives you a text input for finding any value containing the selected text. You can control whether or not the text has to be an exact match, whether or not the search is case sensitive, and whether or not the search is a regular expression.
When you choose to edit the filter by clicking on the filter name and doing 'Edit the Filter' from the editor, you can configure a variety of options.
If 'Define Explicit Values' is checked, you can put in a list of values that you want to display when the filter is shown. For example, you might have a value that's not currently present in your data that you want to filter against. You can use these explicit options to define what is shown in the filter.
If 'Only Show if Data is Present' is checked, the filter will be hidden on the report or dashboard if the field for the filter doesn't contain any data.
If 'Reverse Sort' is checked, the filter will reverse the sort used for sorting the values shown in the filter.
If 'Maximum Selections Allowed' contains a number, the filter will restrict the number of possible selected values to that number. For example, if you want to have a multi value filter for selection while still restricting to only one possible selection, you could put 1 as the value here.
If 'Don't Show No Values' is checked, No Value will not appear in the multi value filter window. Otherwise, No Value will always be present, even if the data doesn't contain it.
You can associate other multi value filters as parent filters to a multi value filter:
When the user makes a selection in a parent filter, that filter will be applied in turn to the child filter, enabling you to restrict values down.
If 'Case Sensitive' is toggled, the pattern filter will only match values matching the same combination of upper case/lower case as the filter. For example, if the filer is on ABC and the value is abc, the filter won't match that value.
If 'Regex' is toggled, the pattern filter will evaluate as a regular expression.
If 'Auto Wildcard (contains text)' is toggled, the pattern filter will match anything that contains the value entered into the pattern filter. This setting is enabled by default. If this setting is not enabled, the filter will perform an exact match. You can add a * to the pattern value for wildcard, so for example, a filter pattern of A* will match ABC but not CBA.
