Quick BI provides system built-in functions that work consistently across different database types, along with native database functions for calculated fields.
Background explanation
When creating a calculated field, you can use Quick BI's system built-in functions or the native functions of the database.
-
System built-in functions: Calculation functions provided by Quick BI that work consistently across underlying databases. Each function's definition, usage, and examples are described in system built-in functions.
For supported data sources, see data source function item list.
-
Database functions: Native functions provided by the underlying database. The calculated field panel displays the available functions based on the database type. For usage details, consult the official database documentation.
System built-in functions
Quick BI supports the following system built-in functions:
-
Aggregate functions summarize data sets before calculation, producing totals, averages, maximums, minimums, and other statistics.
For detailed usage, see aggregate functions.
-
Numeric functions process numerical data by applying mathematical operations to input numbers and returning computed results.
For detailed usage, see numeric functions.
-
Text functions process text strings, enabling you to extract substrings, concatenate strings, change text case, and perform other string operations.
For detailed usage, see text functions.
-
Date functions handle dates and times, supporting date formatting, date difference calculations, current timestamp retrieval, and time unit arithmetic.
For detailed usage, see date functions.
-
Transform functions convert data types to meet specific computational or format requirements, ensuring compatibility and accuracy across different data sources.
For detailed usage, see transform functions.
-
Analysis functions (LOD functions), also known as Level Of Detail Expressions, address inconsistencies in calculation granularity among certain expressions.
For detailed usage, see analysis functions (LOD functions).