Table Advanced Mode
Table Advanced Mode
Embedded Files
Table Advanced Mode
Table Advanced Mode
Table joining can be defined as one of the reporting tools, as it can apply with aggregation and instant calculation to summarize the data from different data sources. Before joining the tables, the column of “Category” and “Value” should be distinguished.
Category Column: provide value(s) for other data source(s) to map with
Value Column: the value(s) can be aggregated, instant calculated or merged to single table view
Concept Diagram
Concept Diagram
Independent Data Sources
Joined Data Sources
Example View of Joined Table
Product ID
Product ID
Item_01
Product Description
Product Description
Computer
Purchased Quantity
Purchased Quantity
190
Sold Quantity
Sold Quantity
92
Balance Quantity
Balance Quantity
98
Product ID
Product ID
Item_02
Product Description
Product Description
Keyboard
Purchased Quantity
Purchased Quantity
250
Sold Quantity
Sold Quantity
91
Balance Quantity
Balance Quantity
159
Product ID
Product ID
Item_03
Product Description
Product Description
Mouse
Purchased Quantity
Purchased Quantity
0
Sold Quantity
Sold Quantity
0
Balance Quantity
Balance Quantity
0
Information !
For those aggregated values, it can be broken down by the function of “Drill Down”.
Example in Run Time:
Case 1: Add Additional Column in Single Data Source
Case 1: Add Additional Column in Single Data Source
Source Table
Source Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Payment Deadline
Payment Deadline
2025-06-12
Due Date
Due Date
3
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Payment Deadline
Payment Deadline
2025-08-03
Due Date
Due Date
60
Information !
The value in “Additional Column” is not saved in the database, it’s calculated instantly.
e.g. Due Date = Now() - Payment Deadline
Conditional Calculation Formula is supported, and the widgets in Form, Page, and Value Stock can be selected.
The column type can be defined as “String”, "Integer”, “Decimal”, “Percent”, "Date”, “Time”, “Date and Time”, "User”, “Group”, “User and Group”, "Dropdown”, “Selection Box”
Case 2: Data Grouping in Single Data Source
Case 2: Data Grouping in Single Data Source
Source Table
Source Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Payment Deadline
Payment Deadline
1,000
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Payment Deadline
Payment Deadline
2,500
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Payment Deadline
Payment Deadline
300
Result Table
Result Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Outstanding Payment
Outstanding Payment
1,300
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Outstanding Payment
Outstanding Payment
2,500
Information !
The value in “Aggregation Column” is not saved in the database, it’s calculated instantly.
Multiple Columns can be grouped.
e.g. to group “Client ID” and “Client Name”
The value of multiple columns can be aggregated by “Max”, “Min”, “Average”, “Sum” and “Count”.
e.g. to sum the value of “Outstanding Payment”
Case 3: Mapping with one data source
Case 3: Mapping with one data source
Setting Criteria
Setting Criteria
Case
Case
3.1
Filter Mode in Record Filters
Filter Mode in Record Filters
Fulfil Filter
Set Mapping Filter within Data Source
Set Mapping Filter within Data Source
✓
Result
Result
INNER JOIN
Case
Case
3.2
Filter Mode in Record Filters
Filter Mode in Record Filters
Fulfil Filter
Set Mapping Filter within Data Source
Set Mapping Filter within Data Source
ㄨ
Result
Result
FULL OUTER JOIN
Case
Case
3.3
Filter Mode in Record Filters
Filter Mode in Record Filters
Not Fulfil Filer
Set Mapping Filter within Data Source
Set Mapping Filter within Data Source
✓
Result
Result
NOT INNER JOIN
Case
Case
3.4
Filter Mode in Record Filters
Filter Mode in Record Filters
Not Fulfil Filer
Set Mapping Filter within Data Source
Set Mapping Filter within Data Source
ㄨ
Result
Result
NO RECORD
Case
Case
3.5
Filter Mode in Record Filters
Filter Mode in Record Filters
Optional Filter
Set Mapping Filter within Data Source
Set Mapping Filter within Data Source
✓
Result
Result
LEFT OUTER JOIN
Case
Case
3.6
Filter Mode in Record Filters
Filter Mode in Record Filters
Optional Filter
Set Mapping Filter within Data Source
Set Mapping Filter within Data Source
ㄨ
Result
Result
FULL OUTER JOIN
Case 3.1 Inner Join - Fulfil filter with mapping rules
Case 3.1 Inner Join - Fulfil filter with mapping rules
Source Table 1: Client’s Category
Source Table 1: Client’s Category
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Source Table 2: Client’s Payment
Source Table 2: Client’s Payment
Client ID
Client ID
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Information !
Mapping Rule is required for inner join.
e.g. Client ID in source 2 = Client ID in source 1
Select ‘Fulfil Filter’ with mapping rule will perform the inner join of source tables
Inner Join: Returns records that have matching related column values in both tables
Client ID is the related column. C2025_03 in Source Table 2 did not match with any Client ID in Source Table 1. Therefore, no records of C2025_03 will be joined.
Case 3.2 Full Outer Join - Fulfil filter without mapping rules
Case 3.2 Full Outer Join - Fulfil filter without mapping rules
Source Table 1: Client’s Category
Source Table 1: Client’s Category
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Source Table 2: Client’s Payment
Source Table 2: Client’s Payment
Client ID
Client ID
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Information !
Information !
Select ‘Fulfil Filter’ without mapping rule will perform the full outer join of source tables.
Full Outer Join: Returns all records when there is a match in either the left or the right table.
Full Outer Join can potentially return a very large result set.
Mapping Rule is absent for a full outer join.
The total records of Full Outer Join
= (Total number of records in Source Table 1) * (Total number of records in Source Table 2)
Case 3.3 Not Inner Join - Not Fulfil Filter with mapping rule
Case 3.3 Not Inner Join - Not Fulfil Filter with mapping rule
Source Table 1: Client’s Category
Source Table 1: Client’s Category
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Source Table 2: Client’s Payment
Source Table 2: Client’s Payment
Client ID
Client ID
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Result
Result
C2025_03
Payment Deadline
Payment Deadline
(Empty)
Information !
Select ‘Not Fulfil Filter’ with mapping rule will perform not inner join of source tables
Not Inner Join: Returns records that have no matching related column values in both tables
Mapping Rule is required for no inner join.
e.g. Client ID in source 2 = Client ID in source 1
Client ID is the related column. C2025_03 in Source Table 1 did not match with any Client ID in Source Table 2. Moreover, C2025_03 has no records in column “Payment Deadline’' on Source Table 2. Therefore, C2025_03 will be joined but with an empty value in the Payment Deadline Column.
Source Table 1: Client’s Category
Source Table 1: Client’s Category
Table 1: Client’s Category
Table 1: Client’s Category
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Table 2: Client’s Payment
Table 2: Client’s Payment
Client ID
Client ID
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
Client Name
Client Name
Category
Category
Result
Result
Payment Deadline
Payment Deadline
Information !
Select ‘Not Fulfil Filter’ without a mapping rule will show no records.
Mapping Rule is absent for empty records.
Not Fulfil Filter is the opposite of Fulfil Filter. When the situation is fulfilled by a filter without mapping rule, the result is full outer join which shows maximum records. The opposite, not fulfilling the filter without mapping rule will show the minimum record, no record.
Case 3.5 Left Join - Optional Filter with mapping rule
Case 3.5 Left Join - Optional Filter with mapping rule
Source Table 1: Client’s Category
Source Table 1: Client’s Category
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Source Table 2: Client’s Payment
Source Table 2: Client’s Payment
Client ID
Client ID
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code
Category
Category
IT
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft co.
Category
Category
Marketing
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Result
Result
C2025_03
Payment Deadline
Payment Deadline
Information !
Select ‘Optional Filter’ with mapping rule will perform left join of source tables
Left Join: Returns all records from the left table, and the matched records from the right table
Mapping Rule is required for left join.
e.g. Client ID in source 2 = Client ID in source 1
All records in Source Table 1 will be shown. Client ID is the related Column. Therefore, records in Source Table 2 with matched Client ID in Source Table 1 will be joined with the Source Table 1. As C2025_03 did not exist in Source Table 2, its Payment Deadline will be empty in the result table.
Case 3.6 Full Outer Join - Optional filter without mapping rules
Case 3.6 Full Outer Join - Optional filter without mapping rules
Source Table 1: Client’s Category
Source Table 1: Client’s Category
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Source Table 2: Client’s Payment
Source Table 2: Client’s Payment
Client ID
Client ID
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Result Table
Result Table
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_01
Client Name
Client Name
Code Ltd.
Category
Category
IT
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_02
Client Name
Client Name
Soft Co.
Category
Category
Marketing
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Result
Result
C2025_01
Payment Deadline
Payment Deadline
2025-06-12
Client ID
Client ID
C2025_03
Client Name
Client Name
Free Org.
Category
Category
Marketing
Result
Result
C2025_02
Payment Deadline
Payment Deadline
2025-08-03
Information !
Select ‘Optional Filter’ without mapping rule will perform the full outer join of source tables.
Full Outer Join: Returns all records when there is a match in either the left or the right table.
Full Outer Join can potentially return a very large result set.
Mapping Rule is absent for a full outer join.
The total records of Full Outer Join
= (Total number of records in Source Table 1) * (Total number of records in Source Table 2)
Case 4: Mapping with multiple data source
Case 4: Mapping with multiple data source
Source Table 1: Product Info.
Source Table 1: Product Info.
Product ID
Product ID
Item_01
Product Name
Product Name
Computer
Product ID
Product ID
Item_02
Product Name
Product Name
Keyboard
Product ID
Product ID
Item_03
Product Name
Product Name
Mouse
Source Table 2: Product Purchase
Source Table 2: Product Purchase
Product ID
Product ID
Item_01
Purchased Amount
Purchased Amount
100
Product ID
Product ID
Item_02
Purchased Amount
Purchased Amount
200
Product ID
Product ID
Item_02
Purchased Amount
Purchased Amount
50
Product ID
Product ID
Item_01
Purchased Amount
Purchased Amount
60
Product ID
Product ID
Item_01
Purchased Amount
Purchased Amount
30
Source Table 3: Product Sold
Source Table 3: Product Sold
Product ID
Product ID
Item_02
Quantity Sold
Quantity Sold
79
Product ID
Product ID
Item_01
Quantity Sold
Quantity Sold
54
Product ID
Product ID
Item_01
Quantity Sold
Quantity Sold
23
Product ID
Product ID
Item_01
Quantity Sold
Quantity Sold
15
Product ID
Product ID
Item_02
Quantity Sold
Quantity Sold
12
Case 4.1 Aggregation in Multiple Data Sources
Case 4.1 Aggregation in Multiple Data Sources
Product ID
Product ID
Item_01
Product Name
Product Name
Computer
Total Purchased
Total Purchased
190
Total Sold
Total Sold
92
Product ID
Product ID
Item_02
Product Name
Product Name
Keyboard
Total Purchased
Total Purchased
250
Total Sold
Total Sold
91
Product ID
Product ID
Item_03
Product Name
Product Name
Mouse
Total Purchased
Total Purchased
0
Total Sold
Total Sold
0
Information !
Data grouping within each data source before table joining
The value in “Aggregation Column” is not saved in the database, it’s calculated instantly.
Case 4.2 Add Additional Column in After Joining
Case 4.2 Add Additional Column in After Joining
Client ID
Client ID
Item_01
Client Name
Client Name
Computer
Category
Category
190
Result
Result
92
Payment Deadline
Payment Deadline
98
Client ID
Client ID
Item_02
Client Name
Client Name
Keyboard
Category
Category
250
Result
Result
91
Payment Deadline
Payment Deadline
159
Client ID
Client ID
Item_03
Client Name
Client Name
Mouse
Category
Category
0
Result
Result
0
Payment Deadline
Payment Deadline
0
Information !
Default Calculation is required.
e.g. Balance Quantity = Total Purchased - Total Sold
The value in “Additional Column” is not saved in the database, it’s calculated instantly.
Case 4.2 based on the result table of Case 4.1
Case 5: Mapping with Virtual Calendar
Case 5: Mapping with Virtual Calendar
Source Table 1: Product Info.
Source Table 1: Product Info.
Product ID
Product ID
Item_01
Product Name
Product Name
Computer
Product ID
Product ID
Item_02
Product Name
Product Name
Keyboard
Product ID
Product ID
Item_03
Product Name
Product Name
Mouse
Source Table 2: Product Purchase
Source Table 2: Product Purchase
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-04
Quantity Sold
Quantity Sold
79
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-03
Quantity Sold
Quantity Sold
54
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-01
Quantity Sold
Quantity Sold
15
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-01
Quantity Sold
Quantity Sold
12
Source Table 3: Product Sold
Source Table 3: Product Sold
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-04
Quantity Sold
Quantity Sold
79
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-04
Quantity Sold
Quantity Sold
54
Product ID
Product ID
Item_01
Issue Date
Issue Date
2025-12-02
Quantity Sold
Quantity Sold
12
Result Table
Result Table
Date
Date
2025-12-04
Product Name
Product Name
Computer
Purchase
Purchase
79
Invoice
Invoice
133
Date
Date
2025-12-03
Product Name
Product Name
Computer
Purchase
Purchase
54
Invoice
Invoice
Date
Date
2025-12-02
Product Name
Product Name
Computer
Purchase
Purchase
Invoice
Invoice
12
Date
Date
2025-12-01
Product Name
Product Name
Computer
Purchase
Purchase
27
Invoice
Invoice
Information !
Data grouping within each data source before table joining
e.g. to group “Product ID” & “Issue Date”
The value of multiple columns can be aggregated by “Max”, “Min”, “Average”, “Sum” and “Count”.
e.g. to sum the Quantity of “Purchase” & “Invoice”
Additionally Mapping with Virtual Calendar for merging the value to the same data from different data sources
e.g. Product ID in source 2 = Product ID in source 1
& Issue Date in source 2 = Calendar Date in Virtual Calendar
The value in “Aggregation Column” is not saved in the database, it’s calculated instantly.
Additional Case Sharing for Table Advanced Mode (Statistics Report)
Additional Case Sharing for Table Advanced Mode (Statistics Report)
Case 1: Annual Leave Report per year
Case 1: Annual Leave Report per year
Case 2: Aging Report of Overdue Payment
Case 2: Aging Report of Overdue Payment
Case 3: Budget Report during budget period
Case 3: Budget Report during budget period
Case 4: Tracking Report on Inventory per day
Case 4: Tracking Report on Inventory per day
Case 5: Sales Revenue in Calendar day
Case 5: Sales Revenue in Calendar day
Information !
To gather information from the database, “Table Advanced Mode” is very useful, but it’s not the only solution.
Source Table 1: Invoice Info.
Source Table 1: Invoice Info.
Invoice ID
Invoice ID
INV_01
Company Name
Company Name
Code Ltd.
Invoice ID
Invoice ID
INV_02
Company Name
Company Name
Soft Co.
Invoice ID
Invoice ID
INV_03
Company Name
Company Name
Free Org.
Source Table 2: Purchase Item
Source Table 2: Purchase Item
Invoice ID
Invoice ID
INV_01
Product ID
Product ID
Item_01
Purchased Amount
Purchased Amount
100
Invoice ID
Invoice ID
INV_01
Company Name
Company Name
Item_02
Purchased Amount
Purchased Amount
200
Invoice ID
Invoice ID
INV_02
Company Name
Company Name
Item_02
Purchased Amount
Purchased Amount
50
Invoice ID
Invoice ID
INV_02
Company Name
Company Name
Item_01
Purchased Amount
Purchased Amount
60
Result Table
Result Table
Invoice ID
Invoice ID
INV_02
Company Name
Company Name
Code Ltd.
Product ID
Product ID
Item_01
Purchased Amount
Purchased Amount
100
Invoice ID
Invoice ID
INV_01
Company Name
Company Name
Code Ltd.
Product ID
Product ID
Item_02
Purchased Amount
Purchased Amount
200
Invoice ID
Invoice ID
INV_02
Company Name
Company Name
Soft Co.
Product ID
Product ID
Item_02
Purchased Amount
Purchased Amount
50
Invoice ID
Invoice ID
INV_02
Company Name
Company Name
Soft Co.
Product ID
Product ID
Item_01
Purchased Amount
Purchased Amount
60
“Result Table” can be performed by using “Case 3.1 Inner Join - Fulfil filter with mapping rules”. At the same time,
It can be handled by adding one more field in “Purchase Item” to store the value of “Company Name”.
Table Advanced Mode
Pros
Adjust the joined tables with at any time
Flexible to add new logic on request
Always show the real-time result
Values can be re-calculated by filtering
Support the function of drill down
Cons
Workflow load is centralized on opening table
Poor performance for joining too much or adding too much instant calculations. Worstly, it can’t be loaded
Saving Values to another Form
Pros
Better performance for loading data
Better for handling complex logic
Keep the value at certain state
Cons
Workflow load is shared to each action for auto updating its value
Pre-defined structure or logic
Data Redundancy
Relay on the values in the database and need time to update all existing records for the modification of logic
Information !
Table Advanced Mode” & “Saving Values to another Form” are not mutually exclusive, and they can be used at the same time for complementarity.
How to Set Table Advanced Mode
How to Set Table Advanced Mode
Go to Page Builder.
2. Click "Data Source Settings" on the Quick Setting Panel of Form Table widget.
3. Select the first data source.
4. Enable/ Tick the check box of “Advanced Mode” which is located on the top right hand side corner.
Add Additional Column
Add Additional Column
Click "Advance" and then click “Add New Column”.
2. Click "New Column" it to show the setting page.
3. Click "Add New" and then click “Input / Integer“ to create a column for the integer type.
4. Modify the Column Title as “Due Date” (for example), and set the Formula for the created column.
5. Click “Save” on the top right hand side corner, and continue the table’s setting.
Information !
Multiple checking conditions are supported.
Widget(s) in Page and Data Source can be used for calculation and condition checking.
Data Grouping
Data Grouping
Click "Advance" and then click “Add Data Grouping”.
2. Click "New Column" it to show the setting page.
3. Select widget(s) to be grouped by clicking
4. Click “+ New Aggregation” to add aggregation conditions.
5. Select “Column to be aggregated”, “Method of aggregation”, and type the “Display Name”.
Expected Result:
6. Click “Save” on the top right hand side corner, and continue the table’s setting.
Information !
Non-grouped/ aggregated column(s) can NOT be shown/ selected in the “Column Settings”.
Mapping with multiple data sources
Mapping with multiple data sources
Click “+ More Data Source” to add additional data sources.
2. Select the second data source.
3. Click "add Condition" to add mapping rule(s).
Expected Result:
4. Click “Save” on the top right hand side corner, and continue the table’s setting.
Information !
The record filtering of the Joined Data Source can be set in “Record Filters” of the table's setting.
Page updated
Report abuse