Filtering Indicator Fields not Appearing in the Table

Preview

You may need to filter out the data of Contract Amount with a Number of 5 without the Number field appearing in the table.

Implementation Method

• Method one: Perform Filter Detail on Contract Amount in the analysis area, with the filtering condition as Number equal to 5.

• Method two: Add a Numeric Dropdown Filter Component, with the filtering field as Number and the filtering condition as Number equal to 5.

• Method three: Convert the Number indicator into a dimension field, set Group Records with Same Value for it, and drag Number in Dimensions into Result Filter for filtering.

Example data: Contract Information.xlsx

Performing Filter Detail

1. Upload the Contract Information table and create an analysis subject.

Click Component to go to the component editing interface, select the Contract Amount field, use Filter Detail, set filtering condition as Number equal to 5, and click OK.

Drag Time of Contract and Contract Amount into the analysis area and set Time of Contract to be grouped by Year.

Demonstration

For details, see section "Preview".

Drag Time of Contract and Contract Amount into the analysis area and set Time of Contract to be grouped by Year.

Creating a Numeric Dropdown Filter Component

Go to the dashboard editing interface, and choose Filter Component > Numeric Dropdown Filter Component.

Drag Number under Contract Information into the field column, select 5 as the filter content, and click OK.

Demonstration

For details, see section "Preview".

Note:

Result Filter is used to filter the calculation results, not to filter the details as the above.

Creating a Component

Drag Time of Contract and Contract Amount into the analysis area and set Time of Contract to be grouped by Year.

Grouping Records with Same Value for Number

Convert Number into the dimension field.

Drag Number into Dimensions, select Group Records with Same Value as the grouping method, and click OK.

Setting the Filter Condition

Drag Number into Result Filter and click Filter to set the filter condition.

Add the filter condition and click OK.