Using two string columns

  • Resolved billyqureshi

    (@billyqureshi)


    5 years, 5 months ago

    Hi
    I have a very simple csv but after hours of searching online and experimenting in sandbox I cannot get it charted.

    The csv is just columns with the first row being survey questions and the remaining rows being answers to the questions.
    All answers are strings. Every question has only a handful of possible answers .

    When creating a chart, I can only select one column that contains string data.
    Therefore, I can’t even create a pie chart of one column/question to show how many times eac answer appeared.
    If i can get the chart to accept two strings columns I could maybe use the grouping function to do this. But I can’t.
    Am I missing something ? It seems what I want to do is very basic yet I can’t do it !

    • This topic was modified 5 years, 5 months ago by billyqureshi.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    5 years, 5 months ago

    Hi billyqureshi,

    Sorry for inconvenience,
    At the moment that is not possible, because logic for creating charts requires one string type column(string, date…) and all others have to be integers or floats.

    Thread Starter billyqureshi

    (@billyqureshi)

    5 years, 5 months ago

    Ok. That’s a shame as I think the plugin is fantastic it just lacks some features I would need. Although I would be surprised if I was the only one wanting to plot something like survey responses!
    Would it be easier to use your plugin to perform a SU calculation on a particular column, and then create a chart using the result of this calculation?

    Plugin Author wpDataTables

    (@wpdatatables)

    5 years, 4 months ago

    Hi billyqureshi,
    Sorry, but we are not sure what you mean by

    “perform a SU calculation on a particular column”

    Can you please explain me in little more details, so we can understand what you mean exactly so there is no misunderstanding later?

    Thread Starter billyqureshi

    (@billyqureshi)

    5 years, 4 months ago

    Sorry. It should have said SUM.
    For example, a spreadsheet with columns where all rows contain only integers (representng frequencies / counts )
    One would want to plot the total sum of the counts for each column.
    Eg column titles : number of adults, number of children
    Rows all contain numbers (each row is a new event)
    Graph should show total number of adults and children for all events eg pie chart.

    The columns would need to be added up.

    That doesn’t seem possible in wpdatatables.

    Plugin Author wpDataTables

    (@wpdatatables)

    5 years, 4 months ago

    Hi billyqureshi,
    Yes like you explain it is not possible to create charts in wpdatatables. It is possible only in premium version if you transpose the column and rows for example

    Item Event1 Event2
    Number of adults 2 2
    Number of children 3 3

    And then to use Formula column to make a sum of adults and children and then to create a pie chart from Item column and Formula(SUM) column. Support for premium features are not allowed here so if you have any further question about this please contact us over our support platform.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Using two string columns’ is closed to new replies.