Please wait...

Grouping in Charts in WordPress

Video versionA video overview of grouping in Charts

Video is currently being re-filmed and is coming soon. Stay tuned!

Chart groupingwpDataTables is deeply integrated with MySQL engine

Charts in wpDataTables have one very useful feature from version 1.7: If you enable this feature the values of the rows with same label will be summed up and rendered as a single series otherwise 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 summed 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:

wdt_IDNameApples
1 John 3,00
2 Paul 6,00
3 George 2,00
4 Ringo 5,00
5 John 6,00
6 George 4,00
7 Ringo 2,00
8 George 2,00
9 Ringo 4,00


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:

Never miss new features!

Join 2000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

We never spam or disclose your address to anyone.