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.



     


    附件列表


    主题: Creating a Dashboard
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy