Creating datasets widgets

This guide walks you through the various options available when configuring a widget powered by Datasets.Geckoboard dashboard widget config for datasets

If you need to get your data into Geckoboard as a dataset, see our Datasets API docs.

Visualization type

The visualization picker allows you to choose between plotting your data as:

  • Number
  • Line chart
  • Column chart
  • Bar chart
  • Leaderboard
  • Table

The options available depends on how you've configured your widget. See our guide to choosing the right visualization for your data.

The widget config panel is broken into several sections unique for each visualization type. All types include Metric, Time and Formatting.


The metric picker allows you to select any of the metrics available from your dataset.

A useful field option here is Record count. Using our example Space Cargo dataset, you could plot the number of orders by day and then split that by category or destination.Record_count

Linked to the metric field, Aggregate calculates a roll-up value from related records. The options are:

Adds all records up and shows the total.
Shows the minimum value.
Shows the maximum value.
Shows average of all values for that record.

To understand why your data is populated in the way it is when you viewing your field options, you can preview your dataset from the dataset options menu in the navigation bar. The preview displays the dataset as a spreadsheet with 30 records.Preview_dataset


The time picker allows you to select timeframe for your data. You can also create a Custom period from the bottom of the select menu.


On the Line, Column and Bar charts visualizations the X-axis displays the Time value. It accepts both Date and Datetime types to display Time, or a String to display the name of the field. You can choose to group (bucket) by Day, Week, Month, or Year.X-Axis_bucketing


The time picker allows you to select timeframe for your data. You can also create a Custom period from the bottom of the select menu.


Filters allow you to dial in to the exact value you care about. Filter options available include:

  • Is: show only those values that the data is
  • Is not: show only those values that the data is not


On the Number, Line, Column and Bar charts visualizations it's possible to show your progress towards a chosen target by setting a goal. In the example below, you can see the data points inside the goal shaded area.

Setting a Starting from value on Number visualizations also enables you to set more meaningful goals.

Status indicators

Adding success and/or negative values to Number and Gauge visualizations allows you to draw attention to changes as they happen. Status indicators will overwrite any goals you set on this widget.status indicators panel on the spreadsheets config screen

Chart Options

Change your Line chart's Y-Axis minimum and maximum values.


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.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.