1. Overview
1.1 Application scenario
Enhance real-time Logical calculation is to confirm whether a specified condition is true or false(boolean logic).
1.2 Use function
Self-service dataset Add a column、Filter
Dashboard Add calculation indicator
2. Function list
| Function | Definition | Example |
|---|---|---|
| IF | Judgement function | IF(store net profit>0,"good","bad") |
| AND | If 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") |
| OR | If all the parameters are false, return 0; and if any parameter is true, return 1. | OR(1+7=9,5+7=11) |
