This guide walks you through the various options available when creating leaderboard widgets from your spreadsheet data.
Select data for your leaderboard widget
Click drag to select the spreadsheet cells you want to visualize. You can also select entire rows and columns or enter the data range into the field.
Leaderboard widgets display:
- 2 lines of data
- The first column is a string
- The second column is numeric
When you're happy with your selection, click .
Edits to your source spreadsheet
If you need to make any edits to your spreadsheet you can manually refresh it from the bottom left corner of the screen. From here you can also switch to a different sheet.
If your source spreadsheet is large and complex you might benefit from extracting the data you need to another spreadsheet specifically for powering your dashboard widgets. For more information, see preparing your spreadsheet for Geckoboard.
Preview your leaderboard widget
Next, you'll see highlighted visualization options for your selection. Click the leaderboard icon. In the bottom corner a preview shows how your widget will look.
To select different cells, hover over the spreadsheet and click to edit selection.
When you're happy with your selection, click .
Switch to reading data in rows
By default, Geckoboard reads the data in columns. When your data series is arranged in rows, click Switch rows and columns.
Tip: Use CONCATENATE for multiple columns
If the information you want to include about the ranked items in your leaderboard span multiple cells in your spreadsheet, you can use the CONCATENATE function. Available in Google Sheets and Excel, CONCATENATE enables you combine the contents of two or more cells into a third separate cell.
In our example, we want to add information about the sales team each rep belongs to. Column A lists the name of each rep, B includes a dash – separator (to avoid a result like NathanRed), and C lists the team they belong to.
For each cell in column D starting from A2, we'll use the formula =concatenate(A2,
B2, C2) to return Nathan – Red. Now when you select Column D as part of your leaderboard's data selection you'll see your merged cells.
Configure your leaderboard widget
Visualization type
The visualization picker allows you to switch between the available options.
Selection contains headers
Toggle off if your first selection cells don't contain headers.
Reverse sort order
Toggle the switch to rank the leaderboard by lowest value first.
Formatting
The Formatting menu allows you to overrule the automatically set number of decimal places used, or add additional information about the values on your widget. For more information, see our guide to using the data formatting options.