This document introduces new features and improvements included in Scuba release 3.12.

New features

Scuba release 3.12 includes the following new features:

  • Date math functions

  • Mode aggregation

  • Set actor and flow properties

  • Flow enhancements

  • Additional enhancements

Date math functions

Several new relative time functions and calendar-aware functions are available. In addition, several existing functions are now calculated based on the time zone set on your Scuba cluster. That is, these functions now use a per-cluster time zone setting that is directly viewable and configurable only by contacting customer support or your technical account manager. If your cluster is configured to use UTC, the behavior of these functions won't change. But if it's configured to use some other time zone, these functions will now honor that time zone.

  • The existing functions that are now time zone aware are as follows:

    • SECOND_OF_MINUTE

    • MINUTE_OF_HOUR

    • HOUR_OF_DAY

    • DAY_OF_WEEK

  • The new calendar-aware (and time-zone-aware) functions are as follows:

    • DAY_OF_MONTH

    • MONTH_OF_YEAR

    • ROUND_TO_YEAR

    • ROUND_TO_MONTH

    • ROUND_TO_DAY

    • ROUND_TO_HOUR

    • ROUND_TO_MINUTE

    • ROUND_TO_SECOND

  • The new timestamp difference functions (which do not use the cluster time zone setting) are as follows:

    • SECONDS_BETWEEN

    • MINUTES_BETWEEN

    • HOURS_BETWEEN

    • DAYS_BETWEEN

    • WEEKS_BETWEEN

Click a function name to see in-product documentation for that function.

See Calculate measures and filters with the expression builder in the User's Guide.

Mode aggregation

In addition to standard statistics like count, sum, and average, you can also find the mode of a population.

The mode is the most common result. For example, the mode of 1, 2, 2, 2, and 9 is 2.

To access mode, when defining a measure in the query builder, select Show then click the default Count to choose from the dropdown menu of functions.

mode.png

Compare populations on the fly with set actor and flow properties

You can now create an actor or flow property that contains a set of values. For example, you can create an actor property that consists of all values of a column for each actor. This lets you quickly filter for certain values within that property, and perform fast on-the-fly comparisons between populations.

See Compare actor or flow properties on the fly with setsin the User's Guide.

Flow enhancements

Scuba release 3.12 includes the following new functionality in flows.

Flow properties that operate on time between flow steps

You can define a flow property according to time between flow steps, time before reaching a step, or time after reaching a step. This lets you see the distribution of any time duration in a flow. It is also useful for segmenting flows according to activities that are longer or shorter than others.

Access time duration flow properties in the flow property builder. Next to Method, select Flow time.

flow_time.png
New flow operators

You can now split a flow path using Last Step, Start Time, End time, Time Total, or Total Events.

flow_operators.png

Additional enhancements

regex_match.png

  • Query sampling, the toggle beneath the Go button in Explore, can be configured to be off by default. A user can still enable sampling on a per-query basis. This default setting is configured per dataset. Contact customer support to change this setting for your dataset.

  • Additional messaging when adaptive sampling activates.

  • You can search lists of boards and knowledge objects by creator.

  • In Explore, you can filter strings by matching PCRE regular expressions. To access regex matching, click matches and select matches regular expression:

  • We've updated the listing page for boards to be consistent with other listing pages.

  • A user with read-only access on an object can now share the object with other users. See Manage users and roles with RBAC.