Single Value Visualizations (Worksheets)

IMPORTANT: This document is specific to Sigma worksheets. To learn about this topic for Sigma’s new Workbooks feature, please visit Single Value Visualizations (Workbooks).

Single Value Visualizations, also known as Big Number Charts, display a single value like total sales, or highest sales volume. They are a great way to display key metrics on a dashboard.

5da632cc602a4.png

Summary of Content

Create a Single Value Visualization
Conditional Formatting of Single Value Visualizations
Related Resources

Create a Single Value Visualization

  1. Create a new chart
  2. Choose the single value visualization icon to change the chart type.
    Screen_Shot_2019-10-24_at_9.55.51_AM.png
  3. Add the data you want to visualize.
    You can create a total first or apply an aggregation directly within the Value box. Simply drag the base value to the value field in the chart. Click the down arrow that appears next to the field to open the chart menu, then choose which aggregation to apply.

Conditional Formatting of Single Value Visualizations

Use conditional formatting to define how you want to visually present various conditions.
Example: If you want to mark percentage values <15% as below target, you can set conditional formatting to display red when such a condition is met.

  1. Create a new Single Value Visualization OR open an existing one.
  2. Open the Format tab in your visualization editor.

    Screen_Shot_2020-06-10_at_5.39.27_PM.png
  3. Click on the subsection titled CONDITIONAL FORMATTING to expand.
  4. Click the blue + Add another rule  button to add your first rule.
  5. Screen_Shot_2020-05-18_at_5.32.35_PM.png
  6. A popup box will appear prompting you to customize your rule. Select your Formatting Rule and enter any required values.
    Screen_Shot_2020-06-10_at_5.52.14_PM.png
  7. Select your Font Color and/or Background Color from the dropdown menus.
  8. Watch as your chart automatically responds to your changes
    Screen_Shot_2020-06-10_at_6.04.06_PM.png

Related Resources

Visualize Yor Data
Conditional Formatting

 

IMPORTANT: This document is specific to Sigma worksheets. To learn about this topic for Sigma’s new Workbooks feature, please visit Single Value Visualizations (Workbooks).