The power user can set the following preferences for the
Cross Tab component.
- Data source controls:
Select from the available data sources in the drop-down list, and then click
Update data source to bind your selection to the
component. (If you are changing data sources, you must do so before entering
your Analytics statement.)
- Analytics Statement:
Enter an Analytics statement to return cross-tab values.
Note: Using fields with too many values in your GROUP BY clauses may
cause your cross tab results table to become too large to be useful.
- Cell Limit: Set a
threshold to prevent too large a grid from being rendered on the
Cross Tab page. In general, you should not make
this value, which represents the number of cells rendered in the cross tab
results table, much larger than the default. A table with many thousands of
cells is time-consuming to render and difficult for the end user to read.
- Respect data source query
state: When this box is checked, the
Cross Tab component is dependent on its data
source query state, which means the metric values should update when the data
source query state changes. When the box is unchecked, it is independent of the
data source query state, so the metric values should remain constant regardless
of the data source query state.
- Test analytics query:
Validate the Analytics statements before loading the metrics into the
component. (This step is required.)
After you test and debug your Analytics query, click
Save.
When you save, the
Configuration section is populated with
metric, row, and column information.
- Configuration: Adjust
the table that your end users will see.
In the
Metrics section, you can configure general
metric options or an individual metric. Click the
... button in the top right corner of the
panel to launch its formatting options, where you can change the axis on which
metrics are displayed or add metric totals.
Note: Totals are computed using the same aggregating function as the
original metric. For example, metrics computed using the average function (AVG)
display an overall average for the Total. Because totals may be confusing in
cases where the ARB function is used, you may not want to display totals in
such cases.
For any individual metric, click the
... button on its label to access formatting
options, where you can change the display name and format the data.
You can drag metrics to reorder them, and remove a metric from the
cross tab result table display by unchecking it.
Note: To improve performance, if you do not want to display a metric,
it is better to remove it from the Analytics statement than it is to uncheck
it.
In the
Row Group and
Column Group section, you can drag items
anywhere in the row and column panels. Each GROUP BY item contains a toggle
that can be used to set ascending or descending order.
- View Options: Modify
the dimensions (in pixels) of the table and its window.
Note: The initial generated table will be fit into the size of the
component, regardless of how many rows or columns there are. You can use these
controls to make the table larger than the component space and navigable with
scroll bars.
- Preview table:
Preview the cross tab display as it will appear to the end user.