#FeatureFRIYAY August: duration as a new data type
Posted On 30/08/2019
If you love to tweak your datasets in Cumul.io, you will be thrilled with a couple of new functionalities we added this month. So, are you curious to find out what’s new in Cumul.io? Read on and discover our latest new features!
A new data type: duration
As you’re probably aware, we have a number of data typesavailable. Cumul.io automatically detects hierarchies, numeric values and dates, but you can easily switch the type of any column, e.g. from numeric to a currency or a hierarchy.
For example, you can switch a column with monetary values like revenue or costs to the ‘currency’ data type, so it automatically displays in your dashboard with the right currency sign.
This month, we added a new brand new data type, called ‘duration’. As the name betrays, this data type reflects the duration of a specific action. For example, how long it takes to deliver an order, to close a support ticket, and so on.
So, how to start using duration? If you want to change a column to a duration, you can simply change your data type in the dataset editor. However, you’ll need to take a look at the format of your data first. Is your original data displayed in seconds, minutes, or maybe in days? Make sure you select the right level of duration. You can choose between years, quarters, months, weeks, days, minutes or (milli)seconds.
Whenever you use a duration value in your dashboards, it will cleanly display the duration with the correct time indication (amount of days, minutes, seconds,…). You can even choose which time indications to display: combine duration levels that fit your data best, whether it’s a combination of years, months, days, minutes or other indications. Have a look at the example below.
Extra options in derived columns & date filters
We’ve added some extras to a couple of existing features, check them out below!
Change the data type of derived columns
Related to the new data type, we have made some changes to our derived columns. Before, derived columns were typically formatted as either date formats, coordinates, hierarchies or numeric values depending on the input it receives in the formula.
However, we now made it possible for you to change derived columns to the ‘currency’ and ‘duration’ data type as well. This could be super helpful in many cases, for example when you have a dataset with 2 different timestamps and you want to show the duration between these two points in time.
To illustrate, let’s say you want to calculate the duration between pick-up time and delivery time with a derived column, using our DATE_DIFF function. Simply apply the duration type to your derived column, and you’re all set!
Due to popular demand, we added ‘Yesterday’ as a new select option in the custom date ranges. If you want to follow up on recent performance fast, this ‘yesterday’ filter will make your life much easier!
Do you often create dashboards that contain more than 1 dataset? Have you wondered how to make your filters work on data from both datasets? This is what we call linked filtering!
In yesterday’s webinar, our customer success team explains how to make the magic of linked filtering happen. In a 15-minute session, you’ll get answers to questions like:
What is linked filtering?
How to link two datasets properly?
How to enable linked filtering in your dashboard?
Are you eager to get started with linked filtering? Rewatch the webinar below and get started in minutes!
More Cumul.io news? Meet us at Data Talks!
Are you excited about what’s next? Well, we’re still working on a lot of new features to add to our platform, and we’ve got some really exciting ones in store for you.
During our Data Talks event, we will announce a bunch of new improvements to our integration, which will make it even easier, faster and more seamless to add dashboards to your application. You wouldn’t want to miss it, and we would sure love to see you there!
Can’t wait to find out more? Register now for the event, and we hope to see you there!