Google Sheets now supports calculated dates
We’ve updated our Google Sheets integration to support dates generated by formula, allowing you to use functions like today()
or today()-1
in your spreadsheets.
We’ve updated our Google Sheets integration to support dates generated by formula, allowing you to use functions like today()
or today()-1
in your spreadsheets.
The Datasets Geck-o-meter now supports the same options as the Number visualisation - so you can apply functions such as Sum, Average, Min, and Max, as well as change the field used for ordering.
We’ve given the Datasets API developer site a massive overhaul!
The new site is split into three sections:
We hope this will make it much easier to get started using the new API, and would love to hear what you think. Check it out at https://developer.geckoboard.com/.
We’ve added some extra size options to our image widget to give you more flexibility over how you layout your dashboard.
Our new Split feature allows you to break down a single metric into multiple series.
This gives you more versatility when working with datasets that have more advanced schemas - such as those where you have entries for multiple categories each day.
We’ve moved and renamed the Advanced Settings controls found in our Salesforce and Spreadsheet integrations. Precision, Abbreviation and Unit Controls can now be found in the new Fine-tune tab. This helps us keep the UI simple, and easy to use, as we give you more control over how your visualisations are rendered.
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’.
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.
Our Datasets Beta now supports multi-series line charts, allowing you to plot multiple metrics from a dataset on the same visualisation.
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.