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

❖Usage scenarios

The multi-source data table can display the data of multiple data sets in the same table, facilitate the data summary of different data sources, simplify SQL statements, and meet the needs of complex industry reports. (for the convenience of distinguishing data from different data sources, we hereby agree to 'use cell background color to distinguish data from different data sets in the following description')

 

❖Binding multiple dataset data

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.

1. Select data set 'query1' and bind data to free table cell, as shown in the figure:

 

2. Switch data set to 'query2' and bind data to free table cell, as shown in the figure:

 

➢Be careful:

(1) The methods of binding data, replacing data, and deleting data are consistent with the free tables of previous versions;

(2) A free table supports binding multiple data sets;

(3) For cells between different data sources, it is not supported to select 'parent cell' between settings. You need to set 'cell filter - multi source filter' to establish data association;

(4) Click the cell in the free table, and the data set drop-down box in data on the right panel and the top of the data information area will display the data set used by the current cell.

(5) Click the no data area of the free table to display the latest data set used by the free table.

 

❖Cell Filter

Cell Filter a unique function of the free table component. After selecting a free table cell, you can see this function entry  at the bottom of the binding area of the data module on the right panel. The main functions are as follows:

 

•Cell Filter is an important bridge to associate different data sets in a free table.

For example, the data of a table to be created by a customer needs to come from multiple data sources (such as query1, query2, query3...). When these data sources are not combined into a total data source, the data of each data set is independent and unrelated (see the table below: cell filtering is not set). At this time, the multi-source filtering function in cell filtering can be used to achieve customer needs, The effect is as shown in the figure:

 

 

Function details in the cell filter dialog box (here we will describe the scenario where 'multi source filter' is checked. If 'multi source filter' is not checked, it is the same as general filter):

 

(1)Displays the dataset used by the current cell.

(2)Multi source filtering is not checked by default. When multiple data sources are bound in a free table and there is an extended relationship between data sets, multi-source filtering is available, and other scenarios are grayed out. The unavailable scenario is shown as follows:

(3)Displays the data column of the data source where the current cell is located.

(4)When multi source filtering is checked, the gray setting cannot be modified. The default value is' = '.

(5)Displays the name of the non homologous dataset for which the current cell has an extended relationship.

(6)It shows that the data set selected in [5] is bound to the name of the extended field in the free table.

(7)Show the association between two datasets: query1: column = query2: column

 

•Cell filtering is effective for the current cell, does not affect the filtering of other cell data, and can meet the needs of enterprises for local filtering of data.

For example, a customer wants to display the data with the profile > 100 in each market, but wants the sales data to remain the same. At this time, you can set "cell filter" in the profile cell to realize customer demand, as shown in the figure:

➢Be careful:

(1) Cell filtering is only effective for the current cell and does not affect other cell data;

(2) Cell filtering 'multi-source filtering' and data 'local filtering' coexist and work together;

(3) Cell filtering and free table filtering also coexist;