Summary number and Summary change
Summary number summary-number
Use the Summary number visualization to highlight a large number that is important in a project. This visualization behaves in the following ways, using the associated data source:
- Selects the total of the column if no cell is selected.
- If a single cell is selected, it shows the summary for that cell.
- If more than one cell is selected, it shows the first cell selected.
- If the column is selected, it picks the first cell value in the column.
As part of the visualization settings, specific Summary number options are available.
Select Abbreviate value to abbreviate intelligently the number 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 |
Summary change summary-change
Use the Summary Change visualization to show the delta (change) between two numbers.
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 |