As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I am trying out the free version of wpDataTables and it looks promising. But I have many tables from surveys with columns that are text strings. I need to be able to create charts that show the total of the different text string values. For example, bar charts that show the number of "Strongly Agree", "Somewhat Agree" and "Neutral". I see that string values can only be used as labels, and that the string values need to be converted to numeric values in order to chart them. Per your chatbot (not very helpful) I have tried converting the column type to both an integer and a float column, but all that did was change all the text strings to zeros. Is there a way to convert different text strings to different values with the plugin? For example, "strongly agree" = 1, "somewhat agree" = 2, etc. Or do I have to do that in the source data before importing?
Hi Dan,
First off, I apologize for the initial replies from our chatbot—he’s still learning, and we’re training him to better handle various use cases. 😊
You're absolutely right—that wasn't helpful for the scenario you're working on.
Here’s a quick workaround you can use when you want to create a chart which will show how many times each string value/choice appears in your data, such as from a survey or other user input:
Add a Formula column to your source table and set the formula to simply '1'.
This will act as a "Count" field.
When creating a chart:
Select the string column as the first field (for X-axis labels).
Select the "Count" column as the second field (for the numeric series).
Enable the "Chart Grouping" feature.
This will group identical labels and sum their count, displaying them as a single data point.
If you'd like a more detailed step-by-step example, feel free to check out our full article here:
👉 [https://help.wpdatatables.com/en/articles/17-counting-string-values-for-charts]
Let me know if that helps or if you have any other questions!
Kind regards,
Milos
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