Filtering Indicator Fields not Appearing in the Table

  • Last update:  2024-07-26
  • Overview

    Expected Effect

    You may need to filter the data of the field Contract Amount with the value 5 in the field Number, and at the same time, the field Number does not appear in the table.

    5f5301260e4491f53d04a81f0d6fea9.png

    Implementation Method

    Implementation method one: You can perform Indicator Condition on Contract Amount in the analysis area, with the filtering condition as the value of the field Number equal to 5.

    Implementation method two: You can add a Value Drop-down Filter Component, with the filtering field as Number and the filtering condition as the value of the field Number equal to 5.

    Implementation method three: You can convert the indicator field Number into a dimension field, set the grouping method to group by identical values, and drag the field Number into Filter for filtering.

    Method One: Indicator Condition

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

    Indicator Condition

    1. Create an analysis subject and upload the sample data, go to the component editing page, click the 9702fb61b7618d4dc96cc55ac992b3b.png icon next to the field Contract Amount, select Indicator Condition from the drop-down list, click Add Condition, select the field Number, set the filtering condition to Equal to, Fixed Value, and 5 in sequence, and click OK, as shown in the following figure.

    a5569a88564541ac3636d538bd03a06.png

    5842cd26f38d145ad98cf4ae1a8632c.png

    Drag Time of Contract and Contract Amount into the analysis area and set Time of Contract to be grouped by Year, as shown in the following figure.

    c6bf7dad77f2f6e75c1c14ebba20170.png

    Effect Display

    For details, see section "Expected Effect."

    Method Two: Filter Component

    Component Creation

    Drag Time of Contract and Contract Amount into the analysis area and set Time of Contract to be grouped by Year, as shown in the following figure.

    c6bf7dad77f2f6e75c1c14ebba20170.png

    Value Drop-down Filter Component Creation

    Click the 4f95813b229a937afb7983c055373fd.png button to add a dashboard, go to the dashboard editing page, and choose Filter Component > Value Drop-down Filter Component, as shown in the following figure.

    e754a8031dd131d8bbc5bddd9918100.png

    Drag the field Number in Contract Information into the bar Field, select 5 as the filter content, and click OK.

    168531d95a42d8b48bc45b7b3be7966.png

    Effect Display

    For details, see section "Expected Effect."

    Method Three: Filter

    Component Creation

    Drag Time of Contract and Contract Amount into the analysis area and set Time of Contract to be grouped by Year, as shown in the following figure.

    c6bf7dad77f2f6e75c1c14ebba20170.png

    Group Records with Same Value for Number

    Convert the indicator field Number into the dimension field, as shown in the following figure.

    1dc3e3c60e41938ac17db470f301c20.png

    Drag the field Number into Dimension, click the 9702fb61b7618d4dc96cc55ac992b3b.png icon next to the field, select Group Records with Same Value from the drop-down list, and click OK, as shown in the following figure.

    01807be6497fbed6b1b059059e2acbe.png

    Filtering Condition Setting

    Drag the field Number into Filter and add the filtering condition, as shown in the following figure.

    e98e330b91f29f3cdc6d6c4f7d61cdb.png

    Attachment List


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

    フィードバック

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

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

    不再提示

    9s后关闭

    反馈已提交

    网络繁忙