Welcome to the 4.6 release of Scuba. In addition to the rudimentary bug fixes and performance improvements, there are a number of updates in this version that we hope you will appreciate.
- 4.6.1 Update
Some of the key highlights include:
Round to Week Functionality — You can now round to a week and the dates are aligned to either Sunday or Monday using the ROUND_TO_SUNDAY or ROUND_TO_MONDAY functions.
Queries — Perform operations on fields with empty values in the expression builder as well as compare enumerated values
Flow Properties — Flow Properties relate to specific Flows. New UI enhancements make this connection clear.
Enhanced Data Model Discoverability — Don’t know whether a Knowledge Object is an Event, Actor or Flow? Use the All tab for greater discoverability.
Improved In-Application Filtering — Find your Knowledge Objects and Dashboards more easily with searching for
Monitoring — Back-end work to support Prometheus monitoring.
Round to Week Functionality
Most functionality that lets you round to a week will make a choice for you about when a week starts. However, different use cases might want to delimit the start of a week differently. That’s why we are rolling out two new functions, ROUND_TO_SUNDAY and ROUND_TO_MONDAY which will round to weeks based on when you wish the week to begin.
Exposed Addition in Expression Builder
Often, users will want to use arithmetic in the Expression Builder in order to add filter logic. For example, let’s say that you have the ability to “Like” a comment and “Like” a video you might want to add the number of Likes across these fields. Suppose we have two fields Likes and Loves.
Currently, if we add the columns together with the syntax =[Likes_Comment]+[Likes_Video] we will return
With the new ADD_WITH_NULL_AS_ZERO() function, we will be able to sum across columns that contain null values. In this case, if we specified =ADD_WITH_NULL_AS_ZERO([Likes_Comment], [Likes_Video]) we would return
Every Flow Property is derived from a flow. Now, in the UI, when you navigate to the Flows tab while exploring your Data Model, you’ll see that how many Flow Properties are associated with a given flow. For example, we can see that for the Lifecycle Flow, there are 6 properties associated with that flow.
From there, one can then click and review the Flow Properties associated with the Flow being referenced. This is meant to enable
Enhanced Data Model Discoverability and In-Application Filtering
Don’t remember whether the Knowledge Object you are looking for is an Actor Property, Event Property, Flow, or Flow Property? The All tab makes it easy to search for any of the objects you are looking for. Additionally, with the enhanced filtering logic you can filter to your name and see all the properties that are associated with your username.
We are switching to Prometheus for our in-application monitoring and have done some behind-the-scenes work to lay the groundwork for that switch. Looking forward, one of the benefits of Prometheus is PromQL which will let us set up much better import monitoring.
Import - lz4 compressed input is now accepted.