Okay
  Public Ticket #3429880
Pre-purchase question about charts generation
Closed

Comments

  • Elvis started the conversation

    Hi!

    I'm looking for a solution for upcoming project and I'm not sure, if wpDataTables can cover all the demands of the client.

    It's a survey about how children are going to school (walking, bike...).

    Answers are grouped depending on the age of the children, there are 3 groups/ranges (see the attachment):

    A) 1.Class (green color)
    B) 2,3,4,5.Class (yellow color)
    C) 6,7,8,9 Class (red color)

    I would like to create 3 charts for each group/range from a single spreadsheet/datatable.

    Charts for groups/ranges B and C would have to represent aggregated data (sum) form multiple rows.

    I tested free version of wpDataTables and I'm not sure, if this can be done with Pro version.

    I hope I was clear enough.

    Regards, Elvis

    Attached files:  data_eng.jpg

  • Elvis replied

    I've just realized, that pie chart is not an option because of the 2 columns limitation.

    If I'm correct, I could use for example Column chart with Grouping option?

  •  1,846
    Miloš replied

    Hi Elvis,

    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.

    -

    Yes, data like this which will be stored in multiple Columns/series for charts like that,

    it can't all be in the same Chart if you have to use the Pie chart type.

    Exactly as you said, for a Pie chart you can only pick one Column to provide the 'slices' with percentage for a Pie.

    But you could use multiple pie charts and set them on the same page, next to each other,

    that could be an option;

    or you can try with another Chart Type, as Column chart, sure.

    You can check out all the available chart engines and examples of wpDataCharts documentation here .

    -

    I will give you an example, if you will use a Form Plugin to collect the data from user submissions for a Survey,

    then you can use one of our Form integrations to output the data in Tables,

    and thus making Charts from the table(s).

    -

    This is an example where a user needed to make a Survey Form, and each user would have multiple choices,

    which gets saved by the Form,

    they wanted to make a summed up Chart that shows how many times each choice will repeat.

    -

    In this one we use a Gravity Form, but the same 'logic' can be used for any of our Table types.

    Here we add a hidden number field to the Gravity Form,

    that will always have a predefined value of 1 to prepopulate every row of data and it will be used as a "counter" for how many times each choice will repeat.

    Here is my basic example,  i have a multi-select field in a Gravity Form, 

    and we add a hidden number field :

    1476878896.png

    Then I made a few choices by the visitors, on the page with the Form to populate some data.

    This is the linked table :

    8607598731.png

    Now, we will make a chart , and we enable "Chart Grouping" , so that all values that have the same value will group up to add up how many times they repeat  for the chart.

    Here is an example of a pie chart from the data,

    3833896169.png

    and here is an example with a Bar chart

    1645498782.png

    Let me know if that works for your use-case.smile.png

    -

    If you wish to check our Form integrations, 

    they are :

    integration for Forminator Forms, ( a free add-on), 

    Formidable Forms integration;   and  Gravity Forms integration

    Our devs are working on our own Form Plugin, too, but i can't say an ETA when it will be finished.

    -

    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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