Table data can be analyzed using the following tools:
Growth indicator shows changes of value in the cell relative to other values.
To display growth indicators for rows or columns:
Toggle the Growth Indicator switch to active state. The switch is inactive by default, and growth indicator is not displayed.
Select the For Rows or For Columns radio button. The For Rows radio button is selected by default.
Growth indicators will be displayed in the table by rows or columns. Simultaneous displaying of growth indicators by rows and columns is unavailable.
To hide growth indicators, toggle the Growth Indicator switch to inactive state.
Features of displaying growth indicators:
When building growth indicators by rows, the first cell column located relative to table sidehead is skipped.
When building growth indicators by columns, the first cell row located relative to table heading is skipped.
If the previous row/column cell is empty or contains the value that is not equal to the current one, growth indicator is not displayed for such cell.
If several dimensions are arranged by rows/columns and several elements are selected in any of them except for the first one, displaying of growth indicators by rows/columns is unavailable.
If displaying of grand totals and/or subtotals is enabled for the table, growth indicators are not displayed for such cells.
On export of table to XLSX growth indicators are not exported.
The example of displaying growth indicator for rows:
Green arrows show that the value in a cell is greater than the value in a cell to the left. Red arrows show that the value in a cell is less than the value in a cell to the left.
The example of displaying growth indicator for columns:
Green arrows show that the value in a cell is greater than the value in an upper cell. Red arrows show that the value in a cell is less than the value in an upper cell.
Sparklines are small charts located inside a visualizer. Sparklines can be used to show trends in data series. Sparklines are used to visually present large datasets. Sparklines can be displayed for table columns, rows, and totals.
To set up sparkline:
Toggle the Sparkline switch to active state. The switch is inactive by default, sparklines are not displayed.
Select sparkline display option:
By Rows. The checkbox is selected by default. Sparklines are displayed by table rows.
By Columns. Sparklines are displayed by table columns.
Show for Totals. Sparklines are displayed for totals.
NOTE. To display sparklines by totals, row/column totals should be displayed.
Sparklines are displayed as a line chart for table rows, columns, and totals.
To hide sparklines, toggle the Sparkline switch to inactive state.
Features of displaying sparklines:
If the whole row/column contains only one cell with value, the sparkline is not displayed.
If some cells are empty, the sparkline is displayed with gaps.
If displaying of subtotals is enabled for the table, sparklines are displayed for such cells.
On export of table to XLSX, cells with sparklines are displayed as empty.
The example of using sparklines for rows and columns:
See also:
Setting Up Data Visualization | Setting Up the Table Visualizer