Filter indicator fields not displayed in the table

1. Overview

1.1 Expected effect

The user needs to filter out the "Employee ID" data where the "Gender" is female, and the "Gender" field is not expected to appear in the table, as shown in the following figure:

1.2 Implementation ideas

Method 1: Perform "detail filtering" on the analysis area "Employee ID", and the filter condition is that "Gender" is equal to "Female".

Method 2: Add a "text drop-down filter component", the filter field is "Gender", and the filter condition is when "Gender" equals to "Female".

Method 3: Convert the "Gender" indicator into a dimension, merge same items as a group, and drag the "Gender" into the result filter.

2. Method 1: Use detail filtering

Sample data: "FRDemo_Employe_copy"

2.1 Perform detail filtering

Create a dashboard and enter the component editing area, select the "Employee ID" field, perform "Detail Filtering", set the filter condition to "Gender" equal to "Female", and click "OK", as shown in the following figure:

Drag the "Contract Signing Time" and "Contract Amount" into the analysis area, and set the "Contract Signing Time" grouping basis to "Year", as shown in the figure below:

2.2 Effect view

See section 1.1 of this article for details.

3. Method 2: Use filter component

3.1 Create components

Drag the "Hire Dat" and "Employee ID" into the analysis area, and set the "Employee ID" grouping basis to "Year", as shown in the figure below:

3.2 Create a numeric drop-down filter component

Enter the dashboard editing interface and select "Filter component>Text Drop-down Filter Component", as shown in the figure below:

Drag the "Purchase Quantity" under "Contract Fact Sheet" into the field, and select the filter content as "5", and click "OK", as shown in the following figure:

3.3 Effect display

See section 1.1 of this article for details.

4. Method 3: Use result filter

Note: The result filter is to filter the calculation results, rather than detail filtering shown in Section 2 and 3 of this article.

4.1 Create component

Drag the "Hire Date" and "Employee ID" into the analysis area, and set the "Hire Date" grouping basis to "Year", as shown in the figure below:

4.2 Set Gender as merge same items as a group

Convert "Gender" into dimensions, as shown in the figure below:

Drag the "Gender" into the "Dimensions", set the grouping mode as "merge same items as a group", and click "OK", as shown in the figure below:

4.3 Set filter condition

Drag "Gender" into the result filter and set the filter conditions, as shown in the figure below:

Add filter conditions and click "OK", as shown in the figure below: