1. Scene
For the convenience of customers, the product itself provides a large number of general calculation logics, including: field statistics of string type: count, unique count, field statistics of numeric type: count, unique count, sum, average, maximum , minimum value, field statistics method of date type: count, unique count, earliest, latest, etc. If the customer has special calculation logic, the special calculation logic can be opened through the APL low-code customer, and the calculation results are still displayed in BI charts. To learn more about APL's low-code capabilities on the platform, please refer to: APL code introduction.
2. Case
2.1 Case 1
Core Customer Opening Logic: Add a new column [Whether it meets the standard], when [Account Opening Score] is greater than or equal to 200, it will display "1", and if it is less than 200, it will display "0" ("1" is up to the standard, "0" is not up to the standard).
2.2 Case 2
Core Customer Opening Logic: Filter out special data, each customer under each employee in the case, filter out those rows with visit times > 2, and sum the remaining customer visit times.
