反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

Overview of logical function

  • Recent Updates: April 08, 2022

    • 1. Overview

    1.1 Version

    FineBI
    		JARFunction Changes
    5.1--
    5.1.72020-11-05

    Optimize definition of functions

    Clarify the validity of function parameter.

    5.1.112021-04-02Enhance real-time data function check
    5.1.12-Enhance real-time data function check

    1.2 Application scenario

    Enhance real-time Logical calculation is to confirm whether a specified condition is true or false(boolean logic).

    1.3 Use function

    Self-service dataset Add a column、Filter

    Dashboard Add calculation indicator

    2. Function list

    Function
    		DefinitionExample
    IFJudgement functionIF(store net profit>0,"good","bad")
    ANDIf all the parameters are true, return 1; and if any parameter is false, return 0.AND(1+7=8,5+7=12)
    Switch

    If the result of the expression is value 1, the whole function returns result 1. If the 

    result of the expression is value 2, the whole function returns result 2. If the 

    result of the expression is value 3, the whole function returns result 3, and so force

    		SWITCH(1+2,3,"Today is Wednesday",4,"Today is Thursday")
    ORIf all the parameters are false, return 0; and if any parameter is true, return 1.OR(1+7=9,5+7=11)


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭