Advanced BQL Functions
A range of functions in Advanced BQL extends beyond basic querying. This allows users to perform complex data transformations and calculations directly within the Birst environment.
The subsequent sections describe these functions that are included in Advanced BQL:
- DATEDIFF Function
- FIND Function
- FORMAT Function
- FUNCTION and FUNCTIONLOOKUP Functions
- GETPROMPTFILTER and GETPROMPTVALUE
- LET Function
- LOOKUPROW Function
- LOOKUPVALUE Function
- Math Functions and Operators
- Median of a Measure by Breaking Attribute: MEDIAN
- NOW and NOWDATE Functions
- RSUM (Running Sum) Function
- SPARSE Function (Show Attributes That Have No Measures)
- STAT Function
- TRANSFORM Function
- TREND Function