Open the Analysis group of parametersTable data can be analyzed using the following tools:
To enable and set up growth indicators and sparklines, use the Analysis group of parameters on the side panel.
Open the Analysis group of parameters
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 on the Analysis group of parameters. 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.
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.
To hide growth indicators, toggle the Growth Indicator switch to inactive state.
Features of displaying growth indicators
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 in the Analysis group of parameters. 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.
The example of using sparklines for rows and columns:
To hide sparklines, toggle the Sparkline switch to inactive state.
Features of displaying sparklines
See also:
Setting Up Data Visualization | Setting Up the Table Visualizer
Settings button on the