AND/OR Application Among Multiple Filtering Conditions

  • Last update:  2024-07-05
  • Overview

    Application Scenario

    Sometimes you may need to add multiple filtering conditions for combined applications when filtering. This document introduces how to set the AND/OR relationships among multiple filtering conditions.

    580e00693e6d216cb2853dd86142ed6.png

    Function Description

    FineBI supports flexible AND/OR relationship settings among multiple components.

    Example

    This example is aimed at achieving the scenario in the section "Application Scenario". You can know how to add the AND/OR relationships

    You can download the sample data: Contract Information.xlsx.

    Data Preparation

    1. Download the sample data Contract Information, create an analysis subject, and upload the data, as shown in the following figure.

    bcd7c9b0b885d11528dcd476538d4e8.png

    2. Click the component tab to go to the component editing page, click the c11f83d693f633767e6846152119254.png icon next to the field Contract Amount, and select Indicator Condition from the drop-down list.

    4aa7e26acdf09e8e713243d5fe077fc.png

    Detail Filter

    1. Add the first filtering condition for the field Contract Type and set the condition to In, Fixed Value, and Service Agreement in sequence, as shown in the following figure.

    42184cb8f33ec7b08cd7ca7b4910f53.png

    2. Add the second filtering condition, which is in the AND relationship with the first one.

    afd7fabfba0948313b2da92ec8b9b8c.png

    3. Add the third OR condition for the field Contract Type and set the condition to In, Fixed Value, and Long-term Agreement in sequence. Since this is the third addition, the OR condition is at the top level.

    d02fdbe6436091dfd154bfab70de7fe.png

    4. Do not add the AND condition directly when adding the fourth condition. (If you add the AND condition directly, the added condition will be placed at the top level.) 

    76368cc329aa0796a6180412e50c765.png

    The correct way is to click the third filtering condition (to keep the third and the fourth filtering conditions at the same level) and add an AND condition.

    2.2.gif

    Effect Display

    For details, see the section "Application Scenario."

    Attachment List


    Theme: 可視化コンポーネントの作成
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

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

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

    不再提示

    9s后关闭

    反馈已提交

    网络繁忙