New to WpDataTables, but I have a lot of experience with charting programs. I'm trying to create a simple stacked bar chart. The chart will show milage by month by name. So the names will be on the Y-Axis and the miles on the X axis. I want the miles to be stacked by month. So, it would have a different color for January, February, March, etc for each user. This seems to be simple example of a stacked bar chart, but I can't get it to work. The stacked bar chart only allows one text field as input. So, I can't use Name and Month in the chart. I tried looking into the group-by-row option, but I can't seem to get the group-by option to display in the table setup. I'm using a simple manually built table just to test out the charting. I know that the row grouping function only works on a server-side table, but not sure if the manual tables qualify. I really appreciate the help. Thanks
We have little control over this, since chart engines impose this limitation. As you said, only one string-type column can be used to generate a chart, so if you have a column that consists of names, you won't be able to use a column which consists of dates.
Instead, you need to do one of the following:
1. Leave the name column, so each new row consists of a name of the user, and then add new integer columns which represent each date; like this:
Then, a stacked chart would look like this:
2. Leave the date column, and split the names into separate columns, like this:
New to WpDataTables, but I have a lot of experience with charting programs. I'm trying to create a simple stacked bar chart. The chart will show milage by month by name. So the names will be on the Y-Axis and the miles on the X axis. I want the miles to be stacked by month. So, it would have a different color for January, February, March, etc for each user. This seems to be simple example of a stacked bar chart, but I can't get it to work. The stacked bar chart only allows one text field as input. So, I can't use Name and Month in the chart. I tried looking into the group-by-row option, but I can't seem to get the group-by option to display in the table setup. I'm using a simple manually built table just to test out the charting. I know that the row grouping function only works on a server-side table, but not sure if the manual tables qualify. I really appreciate the help. Thanks
Hello Jeff
Thank you for your purchase.
We have little control over this, since chart engines impose this limitation. As you said, only one string-type column can be used to generate a chart, so if you have a column that consists of names, you won't be able to use a column which consists of dates.
Instead, you need to do one of the following:
1. Leave the name column, so each new row consists of a name of the user, and then add new integer columns which represent each date; like this:
Then, a stacked chart would look like this:
2. Leave the date column, and split the names into separate columns, like this:
Then the chart would come out like this:
That's the only way to make it work.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables