Create Number widgets using spreadsheets

The Number widget is the simplest representation of a metric and consists of a single number pulled from a cell you specify. We’ve also made it really easy to visually compare two figures with four comparison visualizations:

  • Sparkline
    • Displays a primary metric with a sparkline (a small line chart) below it.
  • Percentage
    • Displays a primary metric with a percentage change value below it that compares the primary metric with a secondary number.
  • Number change
    • Displays a primary metric with a value change below it that is a calculation of the difference between the primary metric and a secondary number.
  • Goal
    • Displays a primary metric with a goal change below it that is a calculation of the difference between the primary metric and a secondary number

Tip: Remove currency or other symbols from your numeric data to avoid errors.

Before you start

To create a number widget using spreadsheets, use the Widget Selector, located in the top right of the Spreadsheets widget set-up screen, to change the widget type to Number.

Basic Number

The Number widget in its simplest form will display a primary metric.

Basic_number_widget.png

To create a basic number widget using spreadsheets, follow these steps:

  1. Select an individual cell to display in the widget.
  2. The Comparison Visualization slider is set to ON by default, so you can click the Green slider button to turn this OFF.

    Note: It’s not necessary to do this if you’ve only selected one cell.

    Basic_number_setup.gif

Sparkline

The Number widget with Sparkline Comparison Visualization displays a primary metric with a sparkline below it. The sparkline offers a simple illustration of other values in your spreadsheet.

Sparkline_widget.png

To create a number widget with a sparkline, follow these steps:

  1. Click in the Number Selection field.
  2. Select a range of cells from the Spreadsheet Data. The last cell in the range will show as the primary metric in the widget. The more cells in your range, the more detailed your sparkline will be.Sparkline_setup.gif

Percentage

The Number widget with Percentage Comparison Visualization displays a primary metric with a percentage change value below it that compares the primary metric with a secondary number.

Percentage_Change_widget.png

To create a number widget with a percentage change value, follow these steps:

  1. Click in the Number Selection field.
  2. Select a range of cells from the Spreadsheet Data. The last cell in the range will show as the primary metric in the widget. The percentage change will be calculated between the first number in the range and the last number in the range.
  3. If desired, you can change the Percentage Comparison Visualization from green to red to indicate whether the change is Positive or Negative.Percentage_setup.gif

Number

The Number widget with Number Comparison Visualization displays a primary metric with a value change below it that is a calculation of the difference between the primary metric and a secondary number.

Number_widget.png

To create a number widget with a number comparison, follow these steps:

  1. Click in the Number Selection field.
  2. Select a range of cells from the Spreadsheet Data. The last cell in the range will show as the primary metric in the widget. The value change will be calculated between the first number in the range and the last number in the range.
  3. If desired, you can change the Percentage Comparison Visualization from green to red to indicate whether the change is Positive or Negative.Number_setup.gif

Goal

The Number widget with Goal Comparison Visualization displays a primary metric with a goal change below it that is a calculation of the difference between the primary metric and a secondary number.

Goal_widget.png

To create a number widget with a goal comparison, follow these steps:

  1. Click in the Number Selection field.
  2. Select an individual cell or range of cells from the Spreadsheet Data. The last cell in the range will show as the primary metric in the widget.
  3. Click in the Goal field and click another cell from the Spreadsheet Data to use that value as the goal value, or type in a specific number.Number_setup.gif

Adding the finishing touches

To finish creating your widget, follow these steps:

  1. Give your widget a Title.
  2. When you’re happy with your Number widget, click the green Add to dashboard button from the bottom of the screen.Add_to_dashboard.jpg

More ways to visualize your spreadsheets

Now that you’re familiar with how to create a number widget, read our dedicated guides to creating the different visualizations available.

  • Line Chart
    Plots multiple series of values and visualize these trends over a period.
  • Column Chart
    Plots a series of data as vertical columns, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.
  • Bar Chart
    Plots a series of data in a horizontal bar chart, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.
  • Leaderboard
    Consists of a ranked list of items, each with a label and an optional value.
  • Geck-O-Meter
    A gauge visualization to quickly see a metric in comparison to defined minimum and maximum values.
  • Text
    Displays non-numerical data from a cell, or multiple cells, in a spreadsheet.
Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!