We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3928422
Converting text strings to numeric values
Open

Comments

  • Dan started the conversation
    April 9, 2025 at 1:09pm

    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? 

  •  1,895
    Miloš replied
    April 10, 2025 at 6:44pm

    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