Operators
An operator is a symbol that specifies the action performed on one or more operands. Insights dashboard support the following types of operators in calculated columns:
NULL OPERANDS
Insights uses the following logic for operations that include NULL values:
- If the formula contains a
NULLvalue, the result returned in the calculated column is also aNULLvalue.
For example, if one of the rows in the 
Quantity column is NULL, then the result in the calculated column for that row is also NULL:
= 
Unit price*Quantity
Arithmetic operators
Arithmetic operators are used to perform mathematical operations on number data types in queries. Insights supports the following arithmetic operators in calculated columns:
| Operator | Description |
|---|---|
| + (add) | Addition |
| - (subtract) | Subtraction |
| * (multiply) | Multiplication |
| / (divide) | Division |
| % (modulus) | Returns the integer remainder of a division |
+ (add)
Adds one number to another.
- Applicable data types:
BIGINT,DOUBLE
Example
This example adds an item's tax to an item's price:
= Item price+Tax amount
- (subtract)
Subtracts one number from another.
- Applicable data types:
BIGINT,DOUBLE
Example
This example subtracts the claim amount from the amount in a wallet:
= Wallet amount-Claim amount
* (multiply)
Multiplies one operand by another.
- Applicable data types:
BIGINT,DOUBLE
Example
This example multiplies the price of an item by the item quantity:
= Item price*Quantity
/ (divide)
Divides one number (the numerator) by another (the denominator):
- Applicable data types:
BIGINT,DOUBLE
DIVISION WITH 0 (ZERO)
Insights uses the following logic for division operations that include 0:
- If the numerator is
0,0is returned. For example,0/row_count = 0. - If the denominator is
0,0is returned. For example,time_taken/0 = 0. - If the denominator is
null,nullis returned. For example,time_taken/null = null.
Example
This example divides the task count by the job count:
= Task count/Job count
% (modulus)
Returns the integer remainder of a division. For example, 23 % 7 = 2, because the remainder of 23 divided by 7 is 2.
- Applicable data types:
BIGINT,DOUBLE
Example
This example returns the remainder from a division:
= (
Order month-1) % 4 + 1
Comparison operators
Comparison operators are used to compare the value of one operand to another operand in queries. Insights supports the following types of comparison operators in calculated columns:
| Operator | Description |
|---|---|
| = (equal) | Equal to |
| != (not equal to) | Not equal to |
| > (greater than) | Greater than |
| >= (greater than or equal to) | Greater than or equal to |
| < (less than) | Less than |
| <= (less than or equal to) | Less than or equal to |
= (equal)
Returns TRUE if the two operands are equal, and FALSE otherwise.
- Applicable data types:
DATE,TIMESTAMP,BIGINT,DOUBLE,BOOLEAN,VARCHAR
Example
This example evaluates whether the ID equals the recipe ID:
= ID=Recipe ID
!= (not equal to)
Returns TRUE if the two operands are not equal, and FALSE otherwise.
- Applicable data types:
DATE,TIMESTAMP,BIGINT,DOUBLE,BOOLEAN,VARCHAR
Example
This example evaluates whether the start date doesn't equal the end date.
= Start date!=End date
> (greater than)
Returns TRUE if the left operand is greater (or later, for datetime values) than the right operand, and FALSE otherwise.
- Applicable data types:
DATE,TIMESTAMP,BIGINT,DOUBLE
Example
This example evaluates whether the job count is greater than 1000:
= job_count> 1000
>= (greater than or equal to)
Returns TRUE if the left operand is greater (or later for datetime values) than or equal to the right operand, and FALSE otherwise.
- Applicable data types:
DATE,TIMESTAMP,BIGINT,DOUBLE
Example
This example evaluates whether the job count is greater than or equal to 1000:
= job_count>= 1000
< (less than)
Returns TRUE if the left operand is less (or earlier for datetime values) than the right operand, and FALSE otherwise.
- Applicable data types:
DATE,TIMESTAMP,BIGINT,DOUBLE
Example
This example evaluates whether the submission date was before the deadline date:
= submission_date< deadline
<= (less than or equal to)
Returns TRUE if the left operand is less (or earlier for datetime values) than or equal to the right operand, and FALSE otherwise.
- Applicable data types:
DATE,TIMESTAMP,BIGINT,DOUBLE
Example
This example evaluates whether the submission date was on or before the deadline date:
= submission_date<= deadline
Logical operators
Logical operators are used to combine or manipulate conditions in queries. Insights supports the following logical operators in calculated columns:
| Operator | Description |
|---|---|
| AND | TRUE if both boolean operands are TRUE. |
| OR | TRUE if one boolean operand is TRUE. |
AND
Returns TRUE if both the left and right operands are TRUE, and FALSE otherwise.
- Applicable data types:
BOOLEAN
Example
This example evaluates whether both is_completed and is_success are TRUE:
= 
is_completedAND is_success
OR
Returns TRUE if the left, right, or both operands are TRUE, and FALSE otherwise.
- Applicable data types:
BOOLEAN
Example
This example evaluates whether is_in_progress, is_complete, or both are TRUE:
= is_in_progressORis_complete
Last updated: