Viewing All Data

  • Last update:  2024-03-01
  • Overview

    Version

    FineBI VersionFunctional Change
    6.0/
    6.0.2View All Data is ticked by default when you create a component. If the query takes more than five seconds, a prompt "The current query performance is poor, try unchecking use part of the data for query." will occur.
    6.0.3After the prompt occurs, click No Longer Remind to receive no prompts.

    Application Scenario

    View All Data is ticked by default when you create a component. Using all the data for calculation and display ensures the data integrity of all components in the same dashboard as much as possible. If the amount of data is too large and it affects the query performance, you can untick View All Data and try using part of the data for calculation and display.

    Function Description

    When editing the component, tick View All Data to view the calculation results of all data.

    Untick View All Data to view only part of the data when you edit the dashboard. You can view all data when previewing the dashboard.

    Procedure

    Go to the component editing page and you can view  all the calculation results. Untick View All Data to view only part of the calculation results, as shown in the following figure.

     1.gif

    If the query takes more than five seconds, a prompt "The current query performance is poor, try unchecking use part of the data for query." will occur. If you click No Longer Remind, you will no longer receive any prompt.

     2.png

    Untick View All Data to use part of the data (10,000 records) for querying.

     3.png

    The following table describes the rules for displaying data volume.

    OperationStatusDisplay Results
    Tick View All Data by default.EditingDisplays all data.
    Tick View All Data by default.PreviewBoth extracted data and direct-connected data use all the data (both are subject to the limitation of parameter data access volume).
    Untick View All Data.EditingOnly uses part of the data from the table (10,000 records) for calculation.
    Untick View All Data.PreviewBoth extracted data and direct-connected data use all the data (both are subject to the limitation of parameter data access volume).

    iconNote:
    When you use the direct-connected data for calculation and display, if the data volume is large, the performance of the corresponding database affects the data query, that is, the processing speed of the database will directly affect the querying speed of the direct-connected data.



     


    Attachment List


    Theme: 隐藏by Chauvet
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

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

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

    不再提示

    9s后关闭

    反馈已提交

    网络繁忙