Filter dimensions
By default, each dimension item in the table returns the top 10 items for that dimension.
To change the dimension items returned for each dimension:
-
Select a cell in the data block.
-
Select
-
Select Next to display the Dimensions tab.
-
Select
-
Select Filter dimension in the pop-up menu to display the Filter dimension pane.
-
Select Most popular or Specific as the Type.
-
Select appropriate options based on the filter type chosen.
-
Select Apply to add the filter.
-
Report Builder displays a notification to confirm the added filter.
To display applied filters, hover over a dimension. Dimensions with applied filters display a
Change the filter and sort order
A
To change the sort order:
- Select
To change the metric used to filter and sort the data block:
-
Hover over the desired metric component in the Table builder to display additional options.
-
Select
Filter type
There are two ways to filter dimension items: Most popular and Specific
Most popular
The Most popular option allows you to dynamically filter dimension items based on metric values. Most popular returns the highest ranked dimension items based on metric values. By default, the first 10 dimensions items are listed, sorted by the first metric added to the data block.
Page and Rows options
Use the Page and Rows fields to divide data into sequential groups or pages. This feature allows you to pull ranked row values other than the top-most values into your report. And is especially useful for pulling data beyond the 50,000 row limit.
The default for Page is 1 and for Rows is 10. These defaults imply that each page has 10 rows of data. Page 1 returns the top 10 items, page 2 returns the next 10 items, and so on.
The table below lists examples of page and row values and the resulting output.
The table below lists minimum and maximum values for page and rows.
Include 鈥淣o value鈥
In Customer Journey Analytics, some dimensions collect a No value entry. The Include 鈥淣o value鈥 setting allows you to exclude these values from reports. For example, you can create a classification such as the Product Name classification based on the Product SKU key. If a specific product SKU has not been set up with its specific Product Name classification, its Product Name value is set to No value.
Include 鈥淣o value鈥 is selected by default. Deselect this option to exclude entries with no value.
Filter by Criteria
You can filter dimension items based on whether all criteria are met or if any criteria are met.
To set filtering criteria:
-
Select an operator from the operator drop-down list. By default Contains the phrase is selected
-
Enter a search term.
-
Select
-
Select
You can include up to 10 criteria items.
** Specific**
The Specific option allows you to create a fixed list of dimension items for each dimension. Use the Specific filtering type to specify the exact dimension items to include in your filter. You can select items from a list or from a range of cells.
From list
-
Select the From list option to search for and select dimension items.
When you select the From list option, the Dimension items list is populated with dimension items ordered by number of events.
-
Enter a search term in the
-
To search for an item not included in the last 90 days of data, select Show items for the last 6 months to extend the search. After data from the past 6 months loads, Report Builder updates the link to Show items for last 18 months.
-
To delete an item from the Selected items list, select
-
To move an item in the Selected items list, drag and drop the item or select
-
Select Apply.
Report Builder updates the list to show the specific filtering you applied.
From range of cells
Select the From range of cells option to choose a range of cell that contains the list of dimensions items to match.
When you select a range of cells, consider the following restrictions:
- The range must have at least one cell.
- The range can鈥檛 have more than 50,000 cells.
- The range must be in a single uninterrupted row, or column.
Your selection can contain empty cells or cells with values that don鈥檛 match with a specific dimension item.
Quickly filter a dimension
To filter a dimension for which currently no filter is applied:
-
Select
-
Double select a dimension items to add to the filter. Alternatively, select one or more dimension items and drag and drop the selection onto the
