Summary number and Summary change
This article documents the Summary number and Summary change visualizations in
See Summary number and Summary change for the
See
Summary Number visualization summary-number
Use the
This visualization behaves in the following ways:
- If no cell is selected, it compares the first two cell values in the column.
- If one cell is selected, it shows 0, because it compares the cell value to itself.
- If two cells are selected, the first selected cell is taken as numerator and the second as denominator.
- If more than two cells are selected, it only considers the first two for comparison.
- If a range of cells is selected, it compares the first to the last cells selected in the range.
- If the column is selected, it compares the first value to itself, which shows a change of 0.
As part of the visualization settings, specific Summary change options are available.
Select Abbreviate value to abbreviate intelligently the changed value. When selected, enter a number to define the amount of abbreviation. For example:
| table 0-row-3 1-row-3 2-row-3 3-row-3 4-row-3 5-row-3 html-authored no-header | ||
|---|---|---|
| Original value | Abbreviation value | Result |
| $12,011,141.25 | Not selected | $12,011,141.25 |
| $12,011,141.25 | Selected, set to 0 |
$12M |
| $12,011,141.25 | Selected, set to 1 |
$12.0M |
| $12,011,141.25 | Selected, set to 2 |
$12.01M |
| $12,011,141.25 | Selected, set to 3 |
$12.011M |