Grouping / Swim Lanes

To group the nodes in swim lanes, we need to provide the grouping information.

Consider the below example where we have one group and three nodes in it:

Image 1: Sample group view inspired by Process Flows

• We will need additional rows for every group that we create. The last column in the above snapshot is the identifier row for the group

• In addition to the Id, Pid and other entity attributes required for the basic view, we need the following columns for grouping/swim lane view:

Data Column	Mandatory/Optional	Description
Group Id	Mandatory	Id of the Group in the group identifier row
Subtree Id	Mandatory	Specifies the ID of the Group in which the node resides
Group color	Optional	Color coding of the Group background

The data structure required for the above group view is as follows:

Image 2: Data required for the view in Image 1

Manually transforming group information in the required structure can be time-consuming. Instead, you can easily use a few transformation steps in Power Query to create the required data structure.

Resources for Grouping/Swimlane View

These resources will assist you transform your current data structure dynamically to fit the required format for the grouping/swimlane view:

1. Data Structure for Columnar Group View - Inspired by the Process Flow use case

2. Data Structure for Wide Group Views - Inspired by the Warehouse Management use case