System Built-in Functions

System built-in functions: Quick BI provides calculation functions that accommodate differences across underlying databases. This topic offers a comprehensive overview of each function's definition and application, complete with detailed examples. For more information, see system built-in functions.

For a list of data sources supported by system built-in functions, see data source function item list.

Database functions: These are the native functions provided by the underlying database. The system retrieves and displays the relevant function list in the calculated field panel based on the database type. For the functions' usage, you can consult the official documentation.

Aggregate functions play a crucial role in data analysis by summarizing data sets prior to calculation. These functions enable you to derive comprehensive insights from vast data, such as totals, averages, maximums, and minimums.

For detailed usage, see aggregate functions.

Numeric functions are designed to process numerical data, applying mathematical rules to input numbers and returning new numerical results.

For detailed usage, see numeric functions.

Text functions are essential for processing text strings in data analysis, enabling you to extract substrings, concatenate strings, change text case, and more.

For detailed usage, see text functions.

Date functions are utilized in data analysis for handling dates and times, allowing for date formatting, date difference calculations, current timestamp retrieval, and time unit arithmetic.

For detailed usage, see date functions.

Transform functions facilitate data type conversions to satisfy specific computational requirements or data format standards, ensuring data compatibility and accuracy when dealing with various sources or formats.

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).