Could you please explain in more detail what you would like to achieve and provide us with some screenshots or a screen recording/example so we can understand better and provide you with the best solution?
I'm trying to create the chart below, but cannot figure out how to setup relationship between "audience group" and "audience" the "audience group" is the master category, and the "audience" is the sub-category which sits within the groups.
One chart can only be created using one table as the source, so you can't combine multiple tables in a chart. You would need to create a 4th table that would contain all the data you want to plot on the chart. Also, wpDataTables doesn't have sub-categories, so you wouldn't be able to achieve this, unfortunately.
Hello!
I'm having an issue creating proper table relationship for a stacked bar chart.
I'm trying to show the number of items in master categories, but display sub-categories as a stacked column.
I have three tables:
1- Showing the relationship between master category and sub-category
2- Showing number of items in master categories
3- Showing the number of items in sub-categories.
Hi Andrew
Thank you for reaching out to us.
Could you please explain in more detail what you would like to achieve and provide us with some screenshots or a screen recording/example so we can understand better and provide you with the best solution?
What do you mean by master and sub-categories?
I'm trying to create the chart below, but cannot figure out how to setup relationship between "audience group" and "audience" the "audience group" is the master category, and the "audience" is the sub-category which sits within the groups.
Hi Andrew
One chart can only be created using one table as the source, so you can't combine multiple tables in a chart. You would need to create a 4th table that would contain all the data you want to plot on the chart. Also, wpDataTables doesn't have sub-categories, so you wouldn't be able to achieve this, unfortunately.