From version 5.2.5, we have the ability to do row metric grouping, which means grouping metrics when they are moved to rows. The below screenshot shows the row metric groups created in the grid chart.
In the above image, two metric groups are created: KPIs, which contain cost, profit, revenue and Employee, which contains profit per employee and revenue per employee. Users can group single or multiple metrics via the metric grouping option in the hamburger menu.
a. This option will only exist when metrics are in row setup. b. Metrics that are not grouped will be shown “ungrouped”.
Open the hamburger menu of a metric column and hover on to Grouping, then a submenu opens. See the screenshot below.
Click on ‘Manage Metric Grouping’. Then a new window will open. Click on ‘Add New’ to create a group. Then a menu with a group title textbox and dropzones will appear.
Now, drag and drop the objects from the left panel into the dropzone and set the group titles. In this case, we are creating two groups, as below: ‘KPIs’ grouped with the metrics ‘Cost’,’Profit’,’ and ‘Revenue’. ‘Employee’ grouped with the ‘ profit per employee’ and ‘revenue per employee.’ See the below screenshot.
Close the ‘Manage Metric Grouping’ window. Metrics that are not grouped will be displayed as “ungrouped.” This is how the groups appear in the screenshot below.
We can also delete the groups using the below steps.
Column Grouping - Grouping of multiple columns. Row Metric Grouping - Grouping of metrics when they are moved to a row.
Rules:
Column grouping & Row Metric grouping can co-exist.
The column grouping of the various metrics as columns will transform into row metric grouping when the “Metrics” are moved to rows. E.g.,Cost, profit, and revenue metrics are column grouped and will be automatically row grouped when they are moved to rows.
If you move row-grouped metrics to columns, the grouped metrics will be converted to column groups.
E.g., In the Move to Rows scenario, if cost, profit, and revenue metrics are Row Grouped, then when the user moves metrics to columns, these Row Grouped metrics will be Column Grouped. Accordingly Check the gif file for steps 1 and 2.
E.g., The year attribute, cost and profit, revenue metrics are column grouped. When these metrics are moved to rows, the year attribute will remain column grouped and the “cost” ,profit and “revenue” metrics will be grouped in rows.
See the image below. The Grouped column has been moved to row grouping.