Read more about Data Workbench’s End-of-life announcement.
Information about working with filter conditions including creating a new filter and adding a condition to a new filter.
Open a filter editor in your workspace by right-clicking Add Visualization > Filter Editor.
-or-
If you already have a filter editor open and a filter loaded, right-click the current filter’s name and click New Blank Filter.
Create a new filter. Make sure that Design Filter is highlighted (as opposed to Apply Filter), indicating that you are working in Design Filter mode.
Right-click within the area marked Right-click to build filter and select one of the following options:
Select the type of condition to add to the filter.
The following table provides descriptions of the available filter condition types:
Condition Type | Description |
---|---|
workspace selection |
Defines a filter condition based on the selections in the workspace. This option is available only if one or more selections exist within the workspace. To view more information about the selection, right-click the condition and click View Details. A callout appears for the condition. If you make another selection in the workspace, you can add the selection as a subcondition of the first selection. The selections are grouped together as logical ANDs. Therefore, the data that is included or excluded by the condition must satisfy all of the workspace selections. |
at least one |
Defines a filter condition based on the existence of at least one (any) element of a dimension that you choose. To edit the condition, right-click the condition and click Change condition to. Click one of the available dimensions. |
formula |
Defines a filter condition based on the formula that you enter. You must use the appropriate syntax for the filter to work.
Note: For information about the syntax for defining filters, see Syntax for Filter Expressions. |
metric value |
Defines a filter condition based on a metric value that you specify. To define the condition, follow these steps:
|
first/last |
Defines a filter that lets you include or exclude a level with a specified dimension. For example, you might specify a first/last filter to include (or exclude): Sessions whose last Page View has a Page of /hme/rts/Our Rates. To define a First/Last condition:
|
The filter in this example defines a first/last filter for users whose last page view was /hme/rts/Our Rates:
(Optional) To add more conditions to your filter, right-click within the area of the window where you are building your filter and select the type of filter (see Step 2) and the condition rule (see Step 3).
Multiple inclusion conditions are grouped together as logical ORs. Therefore, the data included by the filter must satisfy at least one of the defined inclusion conditions. Multiple exclusion conditions also are grouped as logical ORs. To be excluded, data must satisfy at least one of the exclusion conditions.
The filter in this example defines a subset of data consisting of movie viewers (users) who rated lots of movies but did not give any one movie a high score (4 or 5). This filter (appropriately named Very Hard to Please) consists of two conditions:
You can delete conditions only when you are working in Design Filter mode. If you have applied a filter to your workspace, you must click Design Filter to return to Design Filter mode before you can delete one or more of the filter’s conditions.
You can add descriptions to each of the conditions that you add to a filter. You can edit or remove the descriptions as desired.
Descriptions of conditions appear only when you are working in Design Filter mode.
Right-click the condition and click Edit description.
To add or edit a description, type the description in the Edit condition description field. The description appears in quotation marks above the condition in the filter editor window.
To remove a description, click Remove description. The condition remains in the filter editor window.