Product updates

Aggregate functions for more Datasets charts

You can now apply aggregate functions to the Leaderboards, Column, and Bar charts you’ve built with Datasets. This makes it much easier to create charts showing things like ‘Total Sales by Country’, or ‘Average Response Time by Rep’.

datasets-bar-agg

Unit control

We’ve added the ability to adjust what units are displayed on your Salesforce and Spreadsheet visualisations. The new unit controls allows you to manually enter any prefix or suffix up to 3 characters long. This means if you’d prefer to display your currency differently to our default option you now can. As examples you might want Swedish Krona to show as 100 Kr instead of SEK 100, or New Zealand Dollars to just have the $.

We’ll shortly be rolling out these controls, as well as our precision and abbreviation features to our other integrations.

Unit control example

Number styling

To make your metrics stand out, and to allow you to fit more on a widget, we’ve reduced the font size we use to render units. In the example below $, K and % are all now displayed smaller than the numbers.

Currently this change only affects Spreadsheets and Salesforce widgets, but as with our other recent visualisation improvements, we will be rolling these out to more integrations soon.

unit-abbreviation-font-size

Extra Facebook Ads metrics

We’ve added lots more metrics to our Facebook Ads integration. You can now track: Likes, Comments, Follows, CPC, CPM, CTR, Unique Clicks, Reach and much more!

Datasets API

We’ve just released a beta of our new approach to working with custom data in Geckoboard. When you want the highest level of control, or to create widgets using your own data sources, the new Datasets API is the best way to get that data into Geckoboard.

There’s just one data type - a simple, tabular structure called a Dataset - from which you can create a whole variety of different widgets using our powerful editor.

Building widgets from a dataset

It’s simple to try out different visualisations to find the one that’s most appropriate for your dashboard, and to make changes as your needs evolve. The editor also makes it possible for non-developers to make new widgets and change existing ones without having to ask for more development time.

To get started, take a look at the documentation for the new API, and then create your first dataset! We’d love to hear your feedback to help us shape the feature while it’s in beta.

Line chart styling

We’ve updated our old style line charts to use straight rather than curved lines. This brings our line charts more in line with data visualisation best practices and matches the style we apply to the line charts found in our most recent integrations (e.g. Spreadsheets and Salesforce).

Before:

Line chart before

After:

Line chart after

Precision and abbreviation control

Today we’ve started rolling out extra controls for displaying your number widgets.

Precision and abbreviation control in action

Our new decimal places feature allows you to manually set the precision of numbers in your widgets, so that you can show the level of detail appropriate for your dashboard.

You can also override our automatically-set abbreviations. Numbers can now be shown in their raw state, or as Thousands (K), Millions (M), or Billions (B).

The new Decimal Places and Abbreviation options are currently only available on the Spreadsheets number widget, but we will be rolling the functionality out to other visualisations and integrations in the coming weeks.

This is the first part of a series of improvements we have planned for giving you more control over your visualisations.

Number widget secondary stat

We’ve improved how the number widget’s secondary stat displays a percentage change when the previous value is zero. While what we were doing before was mathematically correct, showing an ‘infinite’ increase or ‘NaN’ isn’t very useful. Now, when your previous value was zero, we always show the absolute rather than relative change. So if your current value is 10 and your previous value was 0 we’ll now show an increase of 10, rather than an infinite percentage increase.

Currently this change just applies to Salesforce, Spreadsheet and Custom number widgets - we’re working on rolling it out across the board.

change from zero