Create leaderboards using spreadsheets

In this article:

Leaderboard consist of a ranked list of items, each with a label and, optionally, a value.

Example_leaderboard.png

Displayed in this example Leaderboard are a sales team and their respective sales over a period of a month. Either numerical or decimal values can be used beside each label, with decimals set as default.

To create a leaderboard using spreadsheets, follow these steps:

  1. Use the Widget Selector, located in the top right of the Spreadsheets widget set-up screen, to change the widget type to Leaderboard.
  2. Click in the Labels field.
  3. Either type in a cell selection (e.g. A1:A17), click and drag over the desired cells, or click to select an entire column or row in the Spreadsheet Data area. As you do this, the cells will highlight and you’ll see a live preview of your Leaderboard.
  4. Click in the Values field and either type in a cell selection (e.g. B1:B17) or click and drag over the desired cells in the Spreadsheet Data area.
  5. Give your widget a Title.
  6. Change the widget size from the default (1x2) to the appropriate size for your Leaderboard.
  7. When you’re happy with your Leaderboard, click the green Add to dashboard button from the bottom of the screen.

Leaderboard_setup.gif

Workaround: Create more than two columns in a leaderboard

Though we don't have a pre-built solution for creating a table in a leaderboard, you can extend our widget to display slightly more info by using a formula called CONCATENATE in Google Sheets or Excel to join the values in separate cells. 

Example

Example_extended_leaderboard.png

In column A there is the Fruit heading, in column C the Assigned heading, and in column E the Amount heading. In column D is the formula that merges the specified cells.

The concatenate formula takes a list of cells and merges them into one result. Because merging for example A1 Fruit and C1 Assigned heading would result in FruitAssigned, we've added a separator column B, which holds a - (space dash space).

Tip: While this example uses just two columns, adding one additional column, it could be extended to as many as you'd like, such as =concatenate(A1, B1, C1, D1, E1) and so on.

So, the full formula in, for example, D1 is =concatenate(A1, B1, C1) which creates Fruit - Assigned.

Tip: You can use any value for a separator, as well as specifying it in the concatenate function itself, such as =concatenate(A1, " - ", C1).

Adding it to a dashboard

Add_concatenate_formula.png

  1. First, choose the Spreadsheets integration.
  2. As this was created in Google Sheets, choose the Google Sheets/Drive source and find the file you created.
  3. Use the Widget Selector, located in the top right of the Spreadsheets widget set-up screen, to change the widget type to Leaderboard.
  4. For the Labels, select the whole of column D by clicking on the D column label.
  5. For the Values, select the whole of column E by clicking on the E column label.Leaderboard_result.png

More ways to visualize your spreadsheets

Now that you’re familiar with how to create leaderboards, 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.

  • Number Widget
    Consists of a single number pulled from a specified cell. Enables you to visually compare two figures with 4 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
      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.

  • 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?
👍

Thank you for your feedback!