Bucketed columns
Last updated
Was this helpful?
Last updated
Was this helpful?
A bucketed column is a column that groups field values into buckets based on conditions. For example, let's say your data includes a Score field with user scores, and you want to use the scores to group users into different roles:
Detractor
Passive
Promoter
To do that, you could create an advanced column like so--
--with the following components:
To create a bucketed column, you add the buckets: and (optionally) buckets_default_label: components to the column definition. Within buckets, define a list, with each list item containing a label and condition. If the condition is met, your label will be displayed. If you don't define a buckets_default_label and none of your conditions match, "Not found" will be displayed.
Conditions are defined like [(optional) field] [comparison] [values]. These comparisons can be ANDed or ORed together.
Conditions
Examples
Greater than a number
>20 or >20.5
Greater than or equal to
>=20
Equal to a number or a string (strings must be surrounded by double quotes.
=20 or ="Tennessee"
Not equal to a number or string
!=20 or !="Tennessee
Checking if a value is null
IS NULL
Checking if a value is in a list of values
IN ("TN", "GA", "FL")
Check if a value occurs within a string
LIKE "domain.com" or LIKE "/a/"
Comparing dates.
BETWEEN "A WEEK AGO" and "TODAY" or BETWEEN "2020-01-01" AND "2020-06-30"
Intelligent date ranges (use PREVIOUS, THIS, or NEXT to define an offset and DAY, MONTH, MTD, QTR, YEAR, or YTD to define the period).
IS THIS MONTH or IS LAST MONTH
ANDing two conditions
sales > 1000 AND sales_date IS THIS MONTH
ORing two conditions
sales > 1000 OR sales IS NULL
By default, each condition will be compared against the main field. Let's look at a sample ingredient--
You can provide an alternative field in the condition itself. This is the same definition with the field provided explicitly.
By providing an alternative field, you can create complex buckets that look at multiple values
Conditions within buckets are evaluated in the order they are defined, which makes defining buckets for continuous values convenient:
