FineBI Version
Functional Change
6.0
/
6.0.8
The settings of the area to be analyzed will be synchronized to all the components in the same subject, reducing reuse time and improving work efficiency.
You can select the fields from all tables in the area to be analyzed and perform cross-table analysis as needed.
The left part of the component editing interface is the area to be analyzed where data can be processed.
Number
Function
Explanation
1
Filtering the tables displayed in the area to be analyzed
All: displays all table data in the subject.
Tables with relationships are displayed in one row, while those without relationships can be filtered separately.
2
Searching for the content in the area to be analyzed
Allow searching table names, fields, and parameters.
3
Settings for the area to be analyzed
Support Add calculation indicator, Add Parameter, sorting fields, and expanding and folding tables.
For details about functions, see the sections below.
4
Fields in the area to be analyzed
Types: fields from various tables, Cross-table fields
Counter: the number of rows in each table
Cross-table fields is made based on the data from the associated tables in Model View, or is TargetName.
Usage: being dragged into the analysis area on the right to make components.
Function: supports Create a drill directory, Detail Filtering, field conversion, Geographic role, Copy, etc.
5
Parameter
Displays the parameters added to the component.
For components made from the same table or associated tables on the same model, the settings of their fields in the area to be analyzed will be synchronized in real time.
Note:
1. The settings in the analysis area will not be synchronized.
2. Synchronizing the field settings in the area to be analyzed will not affect the data tables.
For example, you have calculated gross profit with Table A in Component A to analyze the gross profit of different product categories.
Click Add component to directly analyze the gross profit of different provinces in Component B. You do not need to copy Component A, which simplifies operation and improves field reuse efficiency.
The synchronization logic of the components made from unassociated data tables is as follows:
The synchronization logic of the components made from associated data tables is as follows:
Click > Add calculation indicator to select fields for calculation. For example, you can proceed with the following steps to calculate product profit.
Fields calculated by multiple tables will be displayed under Cross-table fields.
Parameters can be added and bound in components. You can also bind parameters in filter components of a dashboard, which can pass values to the target components.
For example, set filter condition as 2020-12-01, then you can see the data for 15 days before 2020/12/01.
You can choose Sort by type or Not sorting to adjust the display the order of fields.
Sort by type means sorting by the types of fields, including time, text, and value.
Click Expand all to expand all the fields within groups. Click Fold all to fold all groups.
In addition to the above operations, you can also process fields in the area to be analyzed.
Create a drill directory
The first step to dynamic drill
Geographical role
The first step in making a map
Convert to indicator
Analyzes the indicators by grouping them according to values
Convert to dimension
Counts the number of distinct values in a column
Detail Filtering
Filters the detailed data of the original table
Copy
Allows copying fields
Delete
Allows deleting the added fields
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy