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.
Option
Definition
Abbreviate value
Select Abbreviate value to abbreviate intelligently the number value. When selected, enter a number to define the amount of abbreviation. For example:
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
Summarize value by
Choose to display the max, min, mean, median, or sum for a selection of data.
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.
Option
Definition
Show percent change
Show the percent change between the 2 numbers.
Show raw difference
Show the raw difference between the 2 numbers. You can also abbreviate values and show up to 3 decimal places with this option.
Abbreviate value
Select Abbreviate value to abbreviate intelligently the changed value. When selected, enter a number to define the amount of abbreviation. For example:
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:
Summary Change visualization to show the delta (change) between two numbers. 
