Overview

Function Overview

Aloudata CAN supports operators, aggregate functions, window functions, mathematical functions, date and time functions, analysis functions, and other function types.

Function Type	Description
Operators	Arithmetic, comparison, and logical operators.
Aggregate functions	Aggregate functions combine multiple rows into one row. For example, Sum adds numeric values across multiple rows.
Text functions	Text functions extract, concatenate, and replace text. For example, Concat joins multiple text fields or values into one text value.
Mathematical and trigonometric functions	Mathematical and trigonometric functions calculate squares, square roots, trigonometric values, and similar operations. For example, Abs returns the absolute value of the current number.
Date and time functions	Date and time functions calculate or convert date-related data. For example, Datediff calculates the difference between two times.
JSON functions	JSON functions extract data from JSON text.
Window functions	Window functions calculate results within a window. For example, Rank sorts data within a window.
Logical functions	Logical functions define conditional analysis. For example, If creates conditional branches and groups data based on conditions.
Type conversion functions	Type conversion functions convert data to a specified data type.
Analysis functions	Analysis functions support complex analysis scenarios. For example, PowerFix pre-aggregates a metric by specified dimensions and returns multi-row data that can be used to build RFM labels.