Number comparisons

Back to: Index of transforms

Transforms in this section compare numerical data types. Learn more about how to search for and add a transformation.

Equal to

Returns True if the numbers are the same value.

Not equal to

Returns True if the numbers are not the same value.

Greater than

Returns True if the input number is greater than the second number.

Greater than or equal to

Returns True if the input number is greater than or equal to the second number.

Less than

Returns True if the input number is less than the second number.

Less than or equal to

Returns True if the input number is less than or equal to the second number.

Edit number

Overwrite a numeric column editing individual cells in the table.

Numeric formula

Create a new numeric column by combining and writing formulas on other numeric columns.

Number group aggregation

Aggregate a group of numbers into a single number.

Time series number aggregation

Aggregate a time series into a single number.

The available aggregates for number group and time series number aggregations are:

  • Sum
  • Average
  • Standard deviation
  • Maximum
  • Minimum
  • Percentage change
  • Difference
  • Product
  • Count
  • First point
  • Last point

Ceiling

Rounds a number up to the next largest integer.

Floor

Rounds a number down to the next smallest integer.

Coalesce

Returns the first value that is not null, or null if all inputs are null.

Day of month

Gets the day of month from a date as a number.

Day of week

Gets the day of week from a date as a number.

Hour of day

Gets the hour of day from a date as a number.

Month

Gets the month from a date as a number.

Year

Gets the year from a date as a number.

Day of year

Gets the day of year from a date as a number.