I have a set of categorical values in column. For example, red car, blue car, black car. These are strings. I need to create a bar chart that shows the count of each car category by date. As the column is a string I it won’t let me add it to the chart builder. How do I create a count of each category and display it in the bar chart?
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
- This can be achieved by creating an integer column that would always have a predefined value of "1".
When you create the chart, you can then use that along with "grouping", and it should work.
Hi,
I have a set of categorical values in column. For example, red car, blue car, black car. These are strings. I need to create a bar chart that shows the count of each car category by date. As the column is a string I it won’t let me add it to the chart builder. How do I create a count of each category and display it in the bar chart?
Regards
Carl
Hi, Carl.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
- This can be achieved by creating an integer column that would always have a predefined value of "1".
When you create the chart, you can then use that along with "grouping", and it should work.
More details about grouping in charts, on this documentation - https://wpdatatables.com/documentation/wpdatacharts/grouping-in-charts/
- If I didn't describe anything clear enough, or you need more details, I apologize, and in that case, please contact us further.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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