After you have dragged items from the project tree to the analysis pane you will have data results displayed.
- If this is a single item, it will show the results of that item.
- A table is drawn (cross-tab) if it is crossed with another.
When a more complex table is created, a contextual green arrow appears in the top-left cell of that table. Clicking it presents you with a list of options that can then be applied. These might include nest/unNest, grid, stack, and switch.
If the arrow is on the bottom left it controls the down dimension. If the arrow appears on the top right it controls the across dimension of the table.
In this article
1. Analysis Table Options
When relevant, table options become available by clicking on the green triangle in the top-left cell of the table.
a) Nest and unNest
Nest adds another layer/dimension to the analysis.
- Two levels of nesting are supported.
- Currently cannot nest a constructed item in, but can nest into a constructed item, then switch.
- Unnest changes from nesting to stacking multiple variables in the dimension.
- When selecting a subset of elements you need to add them to your analysis. The nest option will then become available.
- Nest is not available for Measures or Grid items.
Switch inverts the nesting; the outer axis becomes the inner axis.
If a grid, or a series of axes with similar elements, are being analyzed, they default into a grid view where the axis labels are in one dimension, and the element labels are in the other.
Also, as you explore your data it is quite common to uncover scenarios where questions have common answers. In order to give flexibility over how these are displayed, you can decide if they would like to see these sequentially in a 'stacked form' or to combine these 'grouped together' into a grid.
If a grid, or a series of axes with similar elements, are being analyzed, they default into a grid view where the axis labels are in one dimension, and the element labels are in the other. Stack brings the elements back into the same dimension as the axis.
The option Flip analysis, under layout, allows you to flip the analysis so what was across moves into the down dimension, and vice versa. This has the same functionality as clicking on the by between the across and down dimensions in the analysis title.
Keep in mind that percentages calculations change when manipulating the layout of your table. By looking at the table information you can easily see the base that has been applied to the analysis. Learn more about bases in your analysis.
2. Select multiple items in a table
Clicking on each row or column header will select items independently, however, when you are working with big tables this can be cumbersome.
Multiple adjacent rows and/or columns can be selected using the shift-click function. This range selecting ability is helpful to apply an action to those selected items or even hide them from the view entirely.
Clicking on one item, then holding the SHIFT key (Windows), and clicking on another item, will result in all items in that range will be selected.
While CTRL-Click is not supported, clicking an individual row or column will still add this to the selected range. Multiple item selection is currently available in tables but not in graphs.