Comparative grid
This grid shows multiple measures for the members of the By dimension. The grid can either show a single date range or two date ranges (This and Last).
|
Comparative grid options |
Explanation |
|
Difference, percent change, mix, etc. |
You can insert these columns by placing your cursor over a heading (e.g.,
This), clicking the menu icon |
|
Expand members |
You can expand members to see subgroupings in the next dimension (if the widget has multiple Group By dimensions). The following methods are available:
|
|
Total and average rows |
To show or hide a total row, average row, and/or subtotal (i.e., checked/unchecked)
row, place your cursor over one of these rows and click the menu icon
|
|
Highlight data |
In explore mode, you can highlight data based on custom criteria and/or percent of the total (i.e. heatmap). To access highlight settings, place your cursor over a column heading, click the drop-down arrow, and select Highlighting from the menu. |
|
In grid settings (in explore mode): |
|
|
The standard grid shows measures in columns and dimension members in rows that may be expanded into a tree hierarchy. Additional grid types are available, including a flat view that expands dimensions into separate columns, swapped rows and columns, and a scorecard. To change the grid type, go to grid settings in the toolkit.
|
|
|
- Grid page size or scrolling |
In grid settings, you can choose how many members to show per page, or turn on infinite scrolling to show all members in a single page (not available if auto-expand is on). |
,
and selecting the column to add.
to
expand an individual member.
