#FeatureFRIYAY April: our pivot table got a big update!
Posted On 24/04/2020
As we are still in full quarantine, it has become harder to go about and explore in the physical world. So, to make sure you can still explore plenty of new stuff virtually, we added a bunch of new features to our platform! Find out what’s new in Cumul.io this month.
A fully revamped pivot table
Our pivot table widget got a huge upgrade. We’ve added new functionalities and improved existing ones, so you can get the most out of our pivot table object.
Improved performance for bigger pivot tables
Are you using pivot tables with large amounts of data? Thanks to performance improvements, your pivot tables will now load much faster. Especially when they are data-heavy, you’ll notice big performance gains.
Pivot table now supports filter interactivity
We added filter interactivity to the pivot table! As a result, you can simply click on a cell in your pivot table to filter any other chart in your dashboard. All you need to do is enable ‘filter on select’ in the settings of your pivot table. And you’re all set! Check it out in the gif below to see how it works.
Heat table options for pivot table
We added conditional formatting options to our pivot table. You can choose how to display your conditional formatting: with text colors, background colors or badge colors. Furthermore, you can fully adapt the color scheme to your liking, and even configure how these colors are assigned: continuous, linear, quantiles or manual ranges.
In addition, this means you can now easily transform any pivot table into a heat table. You can even hide the data values to get the true ‘heat table’ effect, as shown in the pivot table below.
All these settings can be adapted directly from within the dashboard editor.
Easy sorting of pivot table
We added many new sorting options to the pivot table. For example, you can now sort the pivot table on your row header columns. So, in the example below, if you would sort on product “Cantaflex”, the columns will automatically adapt their order to sort the values from low to high or vice versa.
In addition, pivot tables that don’t have columns and contain only 1 measure can easily be sorted as well. Simply try it out below by sorting on the measure “Total Cost”.
Do you want to restore your original pivot table, without any sorting applied? Simply reset the sort functionality in the settings tab.
Set row or column limits
Do you want to limit the number of values that are displayed for each column or row? We’ve added a section to the interface where you can limit this, in addition to specifying the exact amount of records you want to show.
Improved headers & labels
We’ve improved different labels and header options for the pivot table. If you hover over your pivot table, it will now show the measure labels on rows and columns. The same goes for header columns: labels will now be shown upon hovering.
We now also support something we call sticky header columns. This means when you scroll through your pivot table, the header columns will be frozen, so they always stay within your sight.
New functions for plugins
Are you using plugins to connect your own API or data source? We added some new functions that will make any developer’s life easier.
Configure error messages for plugins
Cumul.io plugins can now transmit clear error messages to its users by sending them in the following structured format:
"description": "Bad Request"
"message": "The server did not like your username, dude"
You can configure these error messages in order to inform your users about the reason of their connection problems.
To illustrate, let’s say you build a plugin on top of your own API. This will enable your end users to connect data from your platform to Cumul.io. If that user runs into problems during the connection, they will see the descriptive error messages which you have configured.
As a result, they will understand better what’s going wrong, which will considerably lower any technical support on your side.
Send ‘full filter context’ to plugins
You can now send the ‘full filter context‘ to your plugins. This means you can send all filters on datasets served by the plugin, instead of sending only filters on the dataset selected in the query.
As a result, this can help you to considerably limit the amount of data you have to send in your request, which will improve performance. Sending the full filter context is possible for both basic and pushdown plugins.
New geographical datasets
Do you want to visualize geographical data, but are you missing coordinates or topography data? To assist you, we added a bunch of new open datasets to Cumul.io! You now have access to public geographical datasets covering:
United States on state level
United States on county level
US census tract level datasets
A low-res version of our world countries dataset
A low-res version of our Belgian municipalities dataset
The low-res versions are optimized for performance, so your maps will load on lightning speed! ⚡
Mix and match these geodata with your own data to build beautiful maps! All you have to do is link the two datasets, and you’re good to go. In order to use the dataset, navigate to the ‘Public Datasets’ section and filter on the ‘topology’ tag.
New display values in bar & column chart
You can now choose how you want to display the values in a bar and column chart. Previously, you could already show absolute values, but we’ve added more advanced options for customization. Choose between:
% of maximum bar value
% of category total
no values shown
% of legend total
% of total
This will make it easier to compare values or proportions in your bar and column charts.
Coming soon: a revamped number object
Next to the pivot table, we will soon launch another major chart revamp: the number object! Curious to learn more about it? Tune in for our webinar next week, where we’ll go over all the functions of the new number object.
Which newly added feature do you love most? Browse to Cumul.io and start testing them right away!