Hello adnaan

Thank you for your interest in wpDataTables

You would need to have a value the survey marks, like an X, that is going to be used as a measuring point. Then, that column will be included along with a new integer column, which will always have a "1" as a value.

That "1" is used to count how many times X has been encountered in the table, and when you enable "Grouping" in the chart, you will be able to see how many times X was used for response "1", response "2", response "3", etc.

Please feel free to play around with our sandbox site to see how it all works.

I'm sorry Adnaan, but no.

The grouping option I mentioned was for charts, not tables.

I understood you wanted to create a chart? For the chart to have a grouping function, you need to create a table, as explained in my previous response:

Can you send me the csv file, so I can see what I can do with it?

Hello again Adnaan

Unfortunately, with this structure you won't be able to create a chart that you wish to create.

You would need to have each grade as a column (0 - 5), and questions listed in the first column. So first question is in the first row of the table

I'm afraid you won't be able to create a chart like that with the plugin's built in features, as you would need to duplicate the questions for every entry. 

Every new survey would be the same list of questions repeated in new rows, where customer would add an "X" in a row where the answer would correspond. Like this:

The counter column would group the rows allowing you to group the values.

However, I don't believe this would be useful for your use case.

So, for a custom solution you can check in our documentation about wpDataCharts callbacks. 

• Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API and Chart.js API. 

• All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in Support help center). Huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and google will search only that website). Also, a lot of examples of charts, chart settings and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
• Please note that using hooks or wpdatatable and wpDataChart callbacks requires certain level of programming skills and included support refers only to advice.