Row settings
Row settings vary depending on which component you have dragged into the table. To access table row settings, select
In contrast, Breakdown by position always breaks down the top 3 items, regardless of what they are. Referring back to the example, when you re-open your project, the Marketing Channel breakdowns are tied to the top 3 pages in the table. And not to Homepage, Search Results and Checkout, which are now in rows 4-6.
Calculate percentages by row: the percentages in cells are calculated across the row, as opposed to down the column, with Grand total as the denominator. This calculation is useful for trending percentages.
Show as sum of current rows shows a client-side sum of the rows in the table, which means the total does not de-duplicate metrics like visits or persons.
Show grand total shows a server-side sum, which means the total of de-duplicated metrics.
See
This video demonstrates the functionality using Adobe Analytics. However, the functionality is similarly available in Customer Journey Analytics. Be aware of the differences in terminology between Adobe Analytics and Customer Journey Analytics (for example visits versus sessions).
Change row count
To change the number of rows that are displayed:
-
Click the number next to Rows at the top of the first column of the table.
-
From the drop-down menu, select the number of rows you would like the table to display.
Context-menu
The following context menu options are available when selecting the dimension header.
The following additional context menu options are available when selecting one or more dimension items (first column) or one or more individual cells in the freeform table.
Available on any selected row of a freeform table which is modified as the result of renaming or combining rows. When selected, the Derived field interface opens with the modifications you have made to the freeform table already prefilled. See Inline classifications.
The following additional context menu options are available when selecting a metric column header.
Add a time period column. You are offered several options, where the calendar range of the panel determines the date range:
- Prior date range to this date range
- These date range to this date range.
- Custom date range to this date range. Opens up the Date range builder to specify the date range.
See Date comparison for more information.
Adds compare time period columns. Only available when the dimension is not based on time. You are offered several options determines the date range:
- Prior date range to this date range
- Custom date range to this date range. Opens up the Date range builder to specify the date range.
See Date comparison for more information.
Change row height
You can set the view density of a project to Compact, Comfortable, and Expanded.
Inline classifications inline-classifications-example
Inline classifications enable you to rename or combine rows in a freeform table. And to create a derived field from the modified rows in a table.
The example below illustrates how to use the Rename selected row, Combine selected rows, and Create modified rows as derived field context menu options. And how to reset the modified freeform table.
-
Rename No value row to Other.
-
Select Rename selected row from the context menu in the selected No value row.
-
In the Rename selected row dialog:
- Enter
Otherfor Name. - Select OK.
- Enter
-
-
Combine Men and Women rows to one Adults row.
-
Select Men and Women row.
-
Select Combine selected rows from the context menu from any of the selected rows.
-
In the Combine selected rows dialog:
- Enter
Adultsfor Name. - Select OK.
- Enter
-
-
Create a derived field from the modifications in the freeform table.
-
Select Create modified rows as derived field from the context menu for any selected row in the modified table.
-
Inspect, optionally modify, and save the definition of the derived field based on all modifications made in the table.
-
-
Reset the freeform table to the state before modifications.
-
Select
next to dimension name (modified). -
Select Reset modified rows from the Rows modified popup.
-