Create Leaderboards using spreadsheets
Leaderboard consist of a ranked list of items, each with a label and, optionally, a value. Learn more by reading our introductory guide to leaderboards.
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:
- Use the Widget Selector, located in the top right of the Spreadsheets widget set-up screen, to change the widget type to Leaderboard.
- Click in the Labels field.
- 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.
- 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.
- Give your widget a Title.
- When you’re happy with your Leaderboard, click the green button from the bottom of the screen.
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
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
- First, choose the Spreadsheets integration.
- As this was created in Google Sheets, choose the Google Sheets/Drive source and find the file you created.
- Use the Widget Selector, located in the top right of the Spreadsheets widget set-up screen, to change the widget type to Leaderboard.
- For the Labels, select the whole of column D by clicking on the D column label.
- For the Values, select the whole of column E by clicking on the E column label.
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.