反馈已提交

网络繁忙

Overview of the Settings of the Area to be Analyzed

  • Last update:  2023-05-17
  • Overview

    Version

    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.

     

    Functions

    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

    待分析区域设置概述1.2.1.gif

    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 indicatorAdd 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 roleCopy, etc.

    5

    Parameter

    Displays the parameters added to the component.


    Synchronization Logic of To-be-analyzed Area in Component Editing Interface

    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.

    待分析区域设置概述1.3.gif

    The synchronization logic of the components made from unassociated data tables is as follows:

    3.png

    The synchronization logic of the components made from associated data tables is as follows:

    5.png

    Adding Calculation Indicators

    Click 图片1.png > Add calculation indicator to select fields for calculation. For example, you can proceed with the following steps to calculate product profit.

    待分析区域设置概述2..gif

    Fields calculated by multiple tables will be displayed under Cross-table fields.

    Adding Parameters

    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.

    Sorting Fields

    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.

    待分析区域设置概述4..gif

    Expanding/Folding Fields

    Click Expand all to expand all the fields within groups. Click Fold all to fold all groups.

    待分析区域设置概述5..gif

    More Settings

    In addition to the above operations, you can also process fields in the area to be analyzed.

    Function

    Explanation

    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

    Attachment List


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

    フィードバック

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

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

    不再提示

    10s后关闭