<< Click to Display Table of Contents >> Current:  Create Dashboard > Freestyle Table  Create Freestyle Table

❖Create the Freestyle Table

Drag the freestyle table component of the right side panel of the dashboard  in the component to the dashboard editing area.

 

❖Bind data source

After creating a new free-form table, it will automatically enter the binding mode, and the data binding and replacement functions can be realized by dragging data columns from the right panel data to cells.

Binding method of the freestyle table：

1. Drag and drop the data segment to the freestyle table area to achieve binding, as shown in the figure:

The horizontal and vertical arrows in the Freestyle table data section indicate horizontal expansion and vertical extension, respectively.

2. Drag and drop a data segment directly to the field to be replaced, you can replace the original data segment, as shown in the figure:

❖Remove data segment

Directly select the cell whose data segment you want to remove, and press the Delete key on the keyboard to remove the selected data segment.

 

❖Set up freestyle Table cells

Drag and drop the freestyle table and click on the green binding data icon or click the bind data button on the component's toolbar. This is to associate the freestyle table with the corresponding data in the query. Which field is specifically bound? Need to enter the meta mode and binding through the corresponding settings, the following figure is bound to the freestyle table after the query, the default is two rows and four columns.

In the binding mode, the freestyle table is selected and the form enters the meta mode. Select the cell in Meta mode and click Calculate in the right panel as shown:

[Type] takes values in different ways, including Constants, Grid Computing, Columns.

Constants: This is what you see is what you get. You can double-click the cell directly to edit it, or you can edit it in the value area on the right, as shown in the figure:

 

Grid Computing:By referencing the values of other cells, new data can be calculated, for example, the cell calculation in the following figure: (calculate the value of the cell on the left of the current cell / the value of the second last cell in the previous column of the current cell) + 0.1. For specific use, refer to the section "Grid function":

Columns: Refers to all the columns of the Freestyle table bound data source. However, calculators that do not display hierarchical relationships and aggregation metrics.

 

[Sort] Sort the fields into No sort, ascending, descending, customized sort, manual sort, and advanced sort. Click the option to open the corresponding edit window.

[Name] refers to the name of the cell. Constant: cell+ number; script expression (cell calculation): cellScript+ number; Dimension: column name; Measure: [Aggregate]_ Column name.

[Cell Type] In what way to extract data in the query, there are auto, group, detail, and aggregate.

[Exploded type] refers to the way the field is expanded. It can be expanded for none, horiz., or vert..

After selecting the horiz. extension type, click on the blank area of the dashboard to exit the table's meta mode or preview. The following picture shows horizontal expansion:

After selecting the vert. expansion type, click on the empty area of the dashboard to exit the metadata mode or preview of the table. The following figure shows the vertical expansion:

[Column Parent] You can select a parent cell and expand horizontally according to the expansion of the parent node.

[Row Parent] You can select a parent cell and expand it vertically according to the expansion of the parent node.

[Right click function] Meta mode - select cell - right click: display the right-click function list:

Insert: insert a row / column based on the selected cell, including: insert a row above, insert a row below, insert a row below, and insert a row after

Delete: Based on the selected cell, delete row / column, including: delete row and delete column

Copy cell: copies the contents of the currently selected cell

Cut cell: cuts the contents of the currently selected cell

Paste cell: paste the previously copied or cut cell contents on the currently selected cell

Change cells: merge the selected cells that can form a regular rectangle into one cell. You can select multiple cells by pressing and holding the CTRL key

 

❖Set the number of headers, rows, and columns of freestyle tables

Set the number of headers, rows, and columns of the freestyle table in the right panel - Settings - Number of rows and columns, as shown in the following figure:

[Rows]The default number of rows is 4. You can set the total number of freestyle tables.

[Columns] The default number of columns is 4, you can set the total number of freestyle tables.

[Row Headers]The number of header rows defaults to 0. You can set the number of rows as headers. When a vertical scroll bar appears, the row set as the header row does not scroll with the scrolling of the vertical scroll bar.

[Column Headers]The column number of the header is 0 by default, and the number of columns as the header can be set. When a horizontal scroll bar is present, the column set as the header column does not scroll as the horizontal scroll bar scrolls.