Creating a chart based on Radio answers

Hello,
If we understood correctly what is your goal, it seems you wish to combine having multiple String Type Fields in the same Polar Area Chart?

If that is the case, sorry to disappoint you, but for any of the Charts, it can only accept one String or Date Type Field, and all the other Columns in the Chart can only be numeric for the Series. ( float or integer)

For the Polar Area Chart specifically, you can check out our example on this Documentation Page, we have it for the Chart.JS Engine.
The main rules for this Chart are :

• One string or date column supported (will be used to name the slices)
• Other columns should have numerical values.
• 2 columns strictly required.

So, if you have 10 Fields in your Source Form, and each Field is like a “section” that has a Question, and the User can choose from 3 Radio choices ( we presume it is a text/string data), in that case, you will not be able to put all these in the same Chart.
You can only create several Charts, align them together on the same WP Page to provide the data for each answered Section.

We will also show you a workaround, how you can ‘group the answers’ to show how many times each ‘choice’ has been selected for a Chart.
If you have our Premium wpDataTables, you can add a Formula Column to our connected Table, which is outputting the entries from your source Form, and set the Formula to just always be “1”.
Then you can use that Formula Field as a “COUNT” for the Chart.
And activate “Chart Grouping” option on your Chart.
This way, you can show the statistics of how many times each answer has been picked, for a String Column, for example in a Pie Chart or any other type of Chart.

Or if you use the wpDataTables Lite Version, you can add a hidden numeric Field in your source Form, and just have it pre-populate to always be “1”.
Then you can use that Field as the “COUNT” Numeric Field for our “Chart Grouping” feature.

You can also check out all our other Chart examples here.
We hope that helps.
Kind regards.

• This reply was modified 1 year ago by wpDataTables.

Hello @wpdatatables

No, I don’t want to add 10 string values. I want to use 10 numeric values. The problem is that it doesn’t allow me to add more than 2.

I am working on a self-evaluation form which should result in user seeing a Polar Area Chart based on their responses.

For collecting answers, I am using Forminator. They also have a plugin allowing me to directly use responses to create a chart with your plugin (wpDataTables integration for Forminator Forms).

I already communicated with their support team, and you can read it in this thread.

I am currently experiencing 3 problems:

1. When I select columns (Area1 Score, Area2 Score, …, Area10 Score), the first one gets lost and used for the vertical axis. How to fix this?
   Screenshot: https://prnt.sc/xxEOf4TkL_ug
2. For Chart.js Polar Area Chart I can’t select more than 2 columns, although I need 10. Is this limitation only on the free version of your plugin? Is it possible to use 10 with the paid version?
   Screenshot: https://prnt.sc/NCl8_JOl-P7U
3. Is it possible to dynamically create chart based only on one set of responses (filter for the table that will only show specific submission data dynamically)? Is this only on the premium version of your plugin?

Thanks in advance!

• This reply was modified 1 year ago by madoxx.

Hello,
Firstly our sincerest apologies for missing this comment at the time when you sent it, we just got to it now.
This should not happen again, we thank you for all your patience.
–
1. You are right. When it comes to having more than 2 Columns in an Area Chart :
This is the limitation coming from the Chart Engine itself, and sorry to disappoint you, but there is no way from our Plugins’ end to change that, in other words, to somehow customize that Chart type to allow it having more Columns coming from the source Table.

On this Documentation Page, for the?Chart.JS Polar Area Chart?, as we stated,

?2 columns are?strictly required, so you can add the first Column which will name the slices on the Chart, and the second column is used to provide the data.?

At this time, we do not have any built-in way to get the Polar Area Chart to load more than two Columns from your source Table.

Every chart engine has its own layout and its settings.

We use free libraries for chart engines, and they are limited as to what we can change from within the plugin’s UI.

You can check out?all the available chart engines and examples of wpDataCharts documentation here?.?
Please note that the HighChart and the ApexChart Engines are not available in our free version.
( But we also do not have any way for an Area Chart to have more than 2 columns in the premium version)

If the options you need are not in the chart creation wizard,  you can try to find a custom solution using chart callbacks.

You can check 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. 

That being said, using hooks like that is only available in our Premium Plugin Version, and our Support can only provide basic advice, you can check our examples from the callbacks our devs made, then to try and modify it in order to find your custom solution.
If you have any additional questions on that, please contact our Premium Support here. https://tmsplugins.ticksy.com/
–

2. Your question :
When I select columns (Area1 Score, Area2 Score, …, Area10 Score), the first one gets lost and used for the vertical axis. How to fix this?
Screenshot:?https://prnt.sc/xxEOf4TkL_ug
– There is no way to fix it, because that is not an issue, it is just the way how the Chart works.
The first Column you select for this Chart, it is being served to provide the names of the slices, while the second column you choose is providing the actual chart data.
That is the default behaviour of the Chart Engine itself.
For any Chart Type – the first Column you choose is just for the labels, while the other numeric ones, are to provide the series data.

3. The second question :
For Chart.js Polar Area Chart I can’t select more than 2 columns, although I need 10. Is this limitation only on the free version of your plugin? Is it possible to use 10 with the paid version?
– We covered this subject above.
There is currently no way for us to change that, with the Free or Premium Version.
You can only try some custom solutions with hooks, that is only available in Premium version, and as mentioned above, that is not covered by our Support, you can only check our developer’s custom examples and try to modify them for your goal.

4. The last question :
Is it possible to dynamically create chart based?only?on one set of responses (filter for the table that will only show specific submission data dynamically)? Is this only on the premium version of your plugin?

• The advanced Column filtering is not available in the Free wpDataTables Version.
  You will be able to filter the table and also to have Charts respond to the Table filtering, but if you wish more details about that,
  please open a ticket on our?main Support platform here,

and one of our Agents will respond as quickly as possible.

Premium products are not supported in these forums, as per this comment by www.remarpro.com moderators.

Thank you for understanding. 

Kind regards.