Version
| FineBI Version | JAR Package Version |
|---|---|
6.1.2 | / |
My Analysis
--Calculation Optimization--
WINDOW Function Added
The WINDOW function is suitable for inter-row calculation. Compared to the EARLIER function used in cross-row calculation, the WINDOW function provides a more concise, intuitive, and efficient solution.
For details, see WINDOW Function Overview.
The WINDOW function is commonly used in following scenarios:
Cumulative calculation: Cumulative values are calculated from the beginning of the dataset to the current row.
In-group accumulation: Cumulative values are calculated by group when data is grouped.
Three-row moving average: The moving average of the current row and its two proceeding rows is calculated.
For example, you can use the WINDOW function to calculate the moving average within three months and observe the sales trend, as shown in the following figure.
--Chart Component Optimization--
KPI Card Style Optimization
The KPI card component has been optimized with enhanced style capabilities, improving user experience and production efficiency.
For details, see KPI Card.
Default content format: The KPI component provides five commonly-used content formats for lower learning thresholds and higher production efficiency.
Column splitting available: When customizing styles of rich texts in KPI cards, you can split columns to achieve more flexible layout and display effects.
Legend Optimization
Charts are optimized for bubble charts and rectangular trees by hiding legends by default.
--Dashboard Export--
Dashboard Export by Public Link
When you view dashboards via public links, you can export the dashboards as PDF or Excel files.
For details, see Export Dashboard.
--Filter Component Optimization--
Default Value Setting Supported by Filter Components
The default value of the filter component can provide you with a preset option, allowing the most-used option to be set as the default value for higher viewing efficiency.
For example, Latest Time in List is selected by default in the time component, helping you quickly access the latest records or data.
For details, see Basic Function of Filter Components.
Mobile Terminal
Mobile Layout Preview Supported
You can preview mobile layout instantly during the design.
For details, see Mobile Layout.
System Management
Filtering Tables Referenced in Templates for Task Schedule
In Filter Setting, you could only select data on which you have permissions in Public Data previously, but can select tables in BI templates now in the new version.
Two DB Parameters Added as Visualization Configuration Options
The following two parameters are added for you to set their values on the FINE_CONF_ENTITY configuration page:
SystemOptimizationConfig.shieldFunction: whether to allow BI to use data outside subjects
SystemOptimizationConfig.jdyDataLimit: upper limit of dataretrieval for update
For details, see FINE_CONF_ENTITY Visualization Configuration.
Data Use Permission Missing Reminder Added
When you only have permissions on component data, you can preview data in the directory but cannot use the data to edit a dashboard. After you save the dashboard as a subject, the system will remind you of permission missing. You can reapply to the administrator for the use permission on corresponding data table.
For details, see Permission on Component Data in Public Data.
