6.1.4 Update Log

Table Adaptation Optimization

(1) Standard adaptation is optimized. The system automatically calculates the column width, reducing the frequency of column width adjustment by dragging and easing table creation.

(2) Width adaptation is optimized. You can select an adaptation method under Component Style > Adaptation Display, as shown in the following figure. This ensures that all columns in a table can always be displayed on devices of different sizes, as shown in the following figure.

For details, see Table Adaption.

Table Condition Style Applicable to the Entire Row

The marking effect of the entire row is more eye-catching. You can mark data in an entire row in FineBI 6.1.4.

For example, to mark the entire rows of products with gross profits less than 100,000, drag Gross Profit into the Color bar under Table Property, add a condition, and select Apply Condition Style to Entire Row, as shown in the following figure.

For details, see Table Property.

Map Display Optimization

When GIS is not selected, the component background color is directly used as the map background. You can set the component background color to be transparent.

When GIS is not selected and the color is used as the background, you can determine whether to select Merge Nine-Dash Line to change the display locations of nine-dash lines. The following figure shows the effect.

For details, see Chart Component Style.

Custom Query Condition

When viewing a dashboard, you may often only need to focus on data for a specific department/project or in a time period. In this case, you need to filter corresponding information by filtering components.

The Query Condition function allows you to save commonly-used filtering conditions and quick settings, greatly facilitating quick access. You no longer need to repeatedly adjust filtering conditions every time entering the page, highly improving the query efficiency.

For details, see Custom Query Condition.

Optimized Custom Comparison with the Same/Previous Period

Function Change

(1) In 6.1.4, the system can dynamically compare an indicator with the same/previous period in a custom date range (filtered by a date filter component) when no date field is dragged into the component analysis area.

(2) In 6.1.4, new function items are added for quick calculation of the indicator comparison with the same/previous period, growth value of comparison with the same/previous period, and growth rate of comparison with the same/previous period.

Application Scenario

The custom comparison with the same/previous period is enhanced. When no date field is dragged into the component analysis area, the indicator in the component is dynamically filtered using the time filter component in the dashboard to compare data with the corresponding same/previous period, or the end of the previous period/month/year.

For example, you want the system to automatically calculate the sales growth rate compared with the same period of the previous month (2020-01-01 to 2020-05-01) after selecting a time period ranging from 2020-02-01 to 2020-06-01.

(1) In Custom Comparison with Same/Previous Period, set Calculation Type to Custom Growth Rate and Time Type to Dynamic Time, as shown in the following figure.

Select any date interval to obtain the growth rate compared with the same period of the previous month, as shown in the following figure.

For details, see Custom Comparison with Same/Previous Period.

PERCENTILE_AGG Supported for Extracted Data

For details, see PERCENTILE_AGG and Table Summary Method.

Ranking Formula Change for the EARLIER Function

The ranking formula for EARLIER has changed, requiring +1 to be placed outside the calculation result of the DEF function.

For example, the formula for ranking the store sales is DEF(COUNTD_AGG('Store Name')+1,['Store Name'],['Sales Per Store'>EARLIER('Sales Per Store')])+1.

Manual Field Matching Supported for Subject Data Source Switchover

• After you create an analysis subject, business logics may often change, requiring fields in the dataset to be replaced or the data source table to be updated.

• You want to reuse completed analysis subjects/dashboards by replacing data sources with just one click.

In Lineage View, find the data source corresponding to the dashboard, and switch the data source. You can manually match fields in the data to be switched in Current Project for one-click dataset/field replacement, as shown in the following figure.

For details, see Data Source Switchover for Analysis Subjects.

Dirty Data Repair

FineBI provides the Dirty Data Repair function to help administrators troubleshoot dirty data in FineBI configuration (with manual/automatic repair supported).

For details, see Dirty Data Repair.

Query Acceleration by Sorting

When big data is filtered at the detail level, the current data storage and retrieval methods may aggravate system processing burdens and incur system performance issues such as slow queries. In this case, IT personnel (administrators) can enable Querying Acceleration by Sorting to reasonably set sorting keys for datasets. In this way, the storage structure is optimized so that data is read more efficiently and queried at a higher speed during filtering, optimizing the overall performance.

For example, the Store sales statistics table with large amounts of data often needs to be filtered by shop number. You can select shop number as Sorting Field for query acceleration, as shown in the following figure.

For details, see Query Acceleration by Sorting.