1. Overview
1.1 Version
| FineBI | JAR | Function Changes |
|---|---|---|
| 5.1 | - | - |
| 5.1.7 | 2020-11-05 | Function interpretation optimization clarify function parameter legality |
| 5.1.11 | 2021-04-02 | Real-time data formula verification enhancement |
| 5.1.12 | - | Sampling data formula calibration enhancement |
1.2 Use location
| Use location | Using field types | |
|---|---|---|
| Self-service Dataset | Add new column、Filter | Numeric fields (some functions allow adding some specified parameter values) |
| Dashboard | Add calculated fields |
2. Function list
| Function | Description |
|---|---|
| RAND | Returns a uniformly distributed random number. Each time the worksheet is calculated, the function returns a new random value. |
| SQRT | Returns the square root of an arithmetic number that is not negative. You can find any non-negative number that is the square root of an arithmetic number. |
| LOG10 | Returns the logarithm with a base of 10. |
| FLOOR | Round the parameter number to the end in the direction of decreasing absolute value. |
| LOG | Returns the logarithm of the value by any base number specified. |
| MAX | Returns the maximum value in the parameter list |
| MIN | Returns the minimum value in the parameter list |
| TRUNC | Truncates a number by a certain number of digits and returns an integer or decimal. |
| FACT | Returns the factorial of a number. The factorial of a number is equal to 1*2*3*... *number |
| RANDBETWEEN | Returns a random integer between value1 and value2 |
| LN | Returns the natural logarithm of a number. The natural logarithm is underlain by the constant term e(2.71828182845904). |
| SIGN | Returns the sign of the number. Returns 1 when the number is positive, 0 when it is zero, and -1 when it is negative |
| CEILING | Rounds the parameter number to the nearest integer along the direction of increasing absolute value. |
| MOD | Returns the remainder of the division of two numbers. The positive and negative signs of the result are the same as the divisor. |
PROMOTION | Returns the percentage of value2 lifted over value1 |
| EXP | Returns the nth power of e. The constant e is the base of the natural logarithm and is equal to 2.171828182845904. |
| ACOS | Returns the inverse cosine of the specified value. The inverse cosine value is an angle, and the return angle is expressed in radians. |
| ASIN | Returns the inverse sine of the specified value. The inverse sine value is an angle, and the return angle is expressed in radians. |
| ATAN | Calculates the arctangent of the specified value. The specified value is the tangent of the returned angle, and the returned angle is expressed in radians. |
| ATAN2 | Returns the arctangent of the x and y coordinates. Returns the angle formed by the x-axis and a line through (x_num,y_num) with the coordinate origin (0,0). |
| COS | Returns the cosine of an angle. |
| DEGREES | Converts radians into degrees. |
| PI | A mathematical constant |
POWER | Returns the multiplication power of the specified number |
RADIANS | Convert angles to radians |
| SIN | Calculate the sine of a given angle |
| TAN | Returns the tangent of the specified angle |
