Detail table component style

1. Overview

For video learning, click: table style.

1.1 Versions

1.2 Application scenarios

When you need to adjust the appearance, font of the table, etc, you can use the table component.

1.3 Function introduction

The details table can set title, table font, table row height, style,total row, format, background and interaction properties, as shown in the following figure:

2. Style

Click the "Style" drop-down box, as shown in the following figure:

FineBI has three styles embedded in it. See section 5.2 of the file "style" for details.

See section 5.3 of the file "style" for details of theme color settings.

3. Format

Click the format drop-down box to set the number of displyed rows, whether to display row number information, display serial number and freeze N columns in the detail table, as shown in the following figure:

3.1 Set the number of rows

Note: 5.1.14 version details supports setting the number of rows. Previous versions do not support this setting, and the system defaults to more than 100 rows for automatic pagination.

Sometimes you want to customize the number of  rows in the detail table, and you can set the number.

For example, if the number of rows is set to 10, only 10 rows of data will be displayed in each page details, as shown in the following figure:

Note: the number of paging lines is 100 lines per page by default, and 1-1000 lines per page is supported.

At the same time, you can click to turn the page to view the data, as shown in the following figure:

3.2 Set whether to display row number

Note: 5.1.14 version details supports setting whether to display the current rows and total rows. By default, the details takes 20000 rows of data, and all data is taken for less than 20000 rows. The current rows and total rows are displayed by default. No matter how much data there is in previous versions, the details only shows 1000 rows by default.

When the parts list is displayed, 20000 rows are displayed by default. Hover the mouse over the identification in the figure below to display the actual quantity, as shown in the figure below:

Sometimes, in order to beautify the dashboard, if you want the detail table not to display the number of data, you can untick "display row information" in "component style" → "format", as shown in the following figure:

3.3 Display serial number

Same as the grouping table. For details, please refer to section 7.2 of the file "format".

3.4 Freezing columns

Fix the width of the first n columns in the table (1-10 frozen columns are supported). When the table slides left and right through the scroll bar, the width and position of the frozen fields remain unchanged.

For example, if you need to view the "Product", "Product_types" and "Sales_volume" each salesperson got, you need to freeze and display the two important fields of "Salesperson" and "Region" in the front, and compare them with other columns of data such as "Product_types", you can check freeze under "component style" → "format" and set the first two frozen columns, as shown in the following figure:

The effect is as follows: