Charts in wpDataTables have one very useful feature: grouping. If you enable this feature the values of the rows with same label will be summed up and rendered as a single series, if it’s disabled (as it is by default) all rows will be rendered as separate series.
This can be helpful if you have repeating rows with identical name in your table and you want to show them sum of values for this name in your chart. This feature will also work in combination with Follow table filtering.
It is really simple to activate the grouping for a chart. Just tick this checkbox in the chart create/edit wizard:
Let’s see an example:
We have a table with repeating rows like (George, Ringo and John). When Grouping feature is disabled each row in table will be rendered as a separate series.
Grouping option disabled:
Grouping option enabled: