Grouping by Merge

Version

Expected Effect

The previous document introduces Grouping by Range. If you want to display the specific values merged into one group, you can group the values by merge. For example, as the primary operating regions of a typical company are North China and South China, you want to set the north and south regions with better sales performance as main viewing objects, and consolidate other regions into the group, as shown in the following figure.

Implementation Method

You can achieve this effect by selecting Group from the drop-down list of Data Setting, and customizing the grouping conditions.

Report Design

Report Creation

Create a general report, and enter the SQL statement SELECT * FROM Orders_new to create a dataset named ds1. You can obtain all the orders in Southeast Asia, as shown in the following figure.

Report Style

Drag the fields to the corresponding cells to list the data in all regions. Design the report style, as shown in the following figure.

Grouping Setting

Group and merge the values in the ShipperCountry column.

Select cell A2 where the ShipperCountry values are located, and select Group and Advanced for Data Setting, as shown in the following figure.

Click Custom in the above figure to bring up the Custom Group dialog box, select By Condition and merge the ShipperCountry values into two groups, as shown in the following figure.

Group 1: Name the group North with the common conditions (Column Name:ShipperCountry) Equal to 'Thailand' or (Column Name:ShipperCountry) Equal to 'Myanmar' or (Column Name:ShipperCountry) Equal to 'Laos' or (Column Name:ShipperCountry) Equal to 'Cambodia' or (Column Name:ShipperCountry) Equal to 'Vietnam'.

Group 2: Name the group East with the common conditions (Column Name:ShipperCountry) Equal to 'Brunei' or (Column Name:ShipperCountry) Equal to 'Indonesia' or (Column Name:ShipperCountry) Equal to 'Philippines' or (Column Name:ShipperCountry) Equal to 'East Timor'.

Click the drop-down icon, and select Merge All Others for regions outside the North and East groups.

Effect Display

PC

Save the template and click Pagination Preview. The effect is the same as that shown in section "Expected Effect."

Mobile Terminal

The preview effects on the DataAnalyst app and HTML5 terminal are the same, as shown in the following figure.

For details, you can download the template: Group by Merge.cpt.