#FeatureFRIYAY: we’ve made your dashboards & integration lightning-fast!
Posted On 27/09/2019
September is running to an end. With a productive month and an awesome customer event behind us, it’s time to bring you up to speed again on what’s new in the platform. Let’s break the news!
Millions of data rows? We made your dashboards lightning-fast!
Are you dealing with millions of data rows? Then you might have some concerns about how to handle this data, and the loading speed of your dashboards. With Cumul.io’s recent improvements, you have nothing to worry about!
Because there’s nothing as annoying as having to wait for your dashboards to load, we made sure that you don’t have to go through that pain in Cumul.io. Thanks to recent improvements, your Cumul.io dashboards will load in the blink of an eye, even if they are fed by millions of data rows.
This feature is currently active when uploading local files or when pushing data from your API. In the future, we aim to implement this acceleration for databases & plugin queries as well.
Thanks to optimizations in our query infrastructure, we improved query performance and therefore also speed enormously. Especially when uploading exceptionally large datasets, you’ll be impressed with the speed of your dashboards loading. To exemplify: with our current query type, queries can be up to 35x faster than before on datasets of 25M rows.
Just to give you an example, the dashboard below is built on top of a dataset with 1.5M sales records. Try it out yourself: use one of the filters in the dataset and see how fast it loads!
An even better & faster integration with parameterizable filters
Last Tuesday at Data Talks, we announced some improvements to our integration. So, say welcome to parameterizable filters! That’s a mouthful, so let’s explain a bit more in detail what this is.
A parameter represents a set of values, which you can use in a filter. So for example, if you have a dataset with sales per country, you might want to filter out a specific set of countries.
In that case, you’ll create a parameter called ‘countries’, which contains the values [Brazil, Spain, France]. Once this parameter is created in your dashboard, you can simply reuse it as a filter in multiple charts, so you don’t have to create that same filter over & over again.
But what does this have to do with our integration? This is where it gets really interesting. When your filters use parameters, you can easily override these parameters in dashboard integrations. You can simply change the filter by calling the parameter by name to override the values. So, you only need to change the information in the metadata, instead of having to include dataset & column ids in your filters.
This makes your integration code way less complex, and as always it’s completely secured. Just as an example, check out the code examples below and see how the number of lines drastically shortens when using parameters!
With this improvement, our integration became even faster, and even better! How fast? In the video below, a user managed to create a complete dashboard and integrate it in just a bit more than 5 minutes. To compare: this would take you at least a month if you would develop it yourself, crazy right?
New plugin: Elasticsearch
We’ve added a new data connector with Elasticsearch! Elasticsearch is an open source search and analytics engine for all types of data: textual, numerical, geospatial, structured and unstructured data.
If you’re using Elasticsearch in your organization, you can now connect it in no time to Cumul.io and start building dashboards on top of your Elasticsearch data! Simply click ‘Add Dataset’ and you’ll find the connector between the options.
Not only can you create a hierarchical structure in your dataset with this great tool. You can use it for a lot of other things, such as translating datasets, setting colors in your hierarchy and more.
In this 30-minute webinar, you’ll learn:
how to build hierarchies in your existing datasets;
how to translate dashboards fast, using the hierarchy editor;
using the hierarchy editor for smart coloring in your dashboards;
Want to learn more about our hierarchy editor? Watch the recording of our webinar below, and get started in minutes!
Excited about our new features? Then open up your lightning-fast dashboards, or try out our new parameters in the app!