Overview
Version
FineBI Version | Functional Change |
6.1 | Changed Filter Detail to Indicator Condition. |
Application Scenario
You can use Indicator Condition to filter an indicator value separately.
For example, you can copy the field gross profit to obtain a new field, select Indicator Condition from the drop-down list of the new field, and set shop style to Fashion hall (as the filtering condition) to obtain a new indicator Gross Profit of Fashion Hall.
Function Description
Detail tables do not support Indicator Condition.
Example
A common scenario for the indicator condition filtering is to calculate the proportion.
Component Creation
Create an analysis subject, upload the built-in data table Store sales statistics in FineBI, and add a component, as shown in the following figure.
Indicator Condition Filtering
To obtain a field that only includes the gross profit of the fashion hall, you can filter the field gross profit to display only data of Fashion hall.
1. Copy and paste the field gross profit, name the new field Gross Profit of Fashion Hall, and perform Indicator Condition on the new field, as shown in the following figure.
2. Click Add Condition, select the field shop style, and In, Fixed Value, and Fashion in sequence, as shown in the following figure.
Proportion Calculation
Add a calculation field by using the formula SUM_AGG(Gross Profit of Fashion Hall)/SUM_AGG(gross profit). Then you can obtain the proportion of the fashion hall's gross profit to the total gross profit, as shown in the following figure.
Group Table Creation
Through the operations shown in the following figure, you can obtain the gross profit of the fashion hall in each region and the proportion of each fashion hall's gross profit to the total gross profit.
Finally, set Value Format of the field Gross Profit of Fashion Hall to Percentage.
Display Rule of Indicator Condition Filtering
Single Indicator Condition Filtering
If you perform Indicator Condition on the only indicator field in a table, the entire rows with values that do not meet the filtering condition will be removed from the table.
For example, if you perform Indicator Condition (filtering condition: value of the field Value 3 > 0) on the only indicator field Value 3 in the following table, rows in which the value of the Value 3 field is less than 0 will be removed, as shown in the following figure.
Multi-Indicator Condition Filtering
If you perform Indicator Condition on an indicator field in a component with multiple indicator fields, the entire rows with values that do not meet the filtering condition will not be removed from the table because other values that meet the filtering condition in the rows need to be displayed. But the cells with values that do not meet the filtering condition will be empty. The cells which are originally empty will be still empty in the rows after indicator condition filtering. Empty data values displayed will not participate in the summary calculation.
For example, if you perform Indicator Condition (filtering condition: value of the field Value 3 > 0) on the indicator field Value 3 but do not perform Indicator Condition on the other field Count in the following table, cells where the value of the field Value 3 is less than 0 will be displayed as empty, as shown in the following figure.
Multi-Indicator Condition Filtering Using a Single Field
If you perform Indicator Condition on multiple indicator fields using the same field as the condition , cells where field data's values that do not meet the filtering condition will be displayed as empty and cells in Count where values do not meet the filtering condition will be displayed as 0 in the table. The empty data values will not participate in the summary calculation.
For example, if you perform Indicator Condition (filtering condition: value of the field Value 3 > 0) on the indicator field Value 3 and perform Indicator Condition (filtering condition: value of the field Value 3 < 5) on Count, the following figure shows the filtering effect.
Filtering Condition Description
After setting condition filtering for indicators, you can add filtering conditions through Add Condition or Add Formula.
The following table shows the supported filtering conditions corresponding to different field types after you click Add Condition.
Field Type | Supported Filtering Condition |
Text field | In, Not In, Contain, Not Contain, Begin with, End with, Not Begin with, Not End with, Null, and Not Null |
Date | In, Not In, By, Since, Equal to, Not Equal to, Null, and Not Null |
Value field | Between, Not Between, Equal to, Not Equal to, More than, Less than, More than/Equal to, Less than/Equal to, Null, and Not Null |
