ÃÛ¶¹ÊÓƵ

Summary number and Summary change

Summary number summary-number

Use the Summarize 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.

Summary number visualization

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:

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
Summarize value by
Choose to display the max, min, mean, median, or sum for a selection of data.

Summary change summary-change

Use the MoveUpDown 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.

Summary change visualization showing the delta between two numbers.s

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:

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
recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79