Hi Kirstie,

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

We will need to try to reproduce this on our end in order to confirm if it is a bug or a current limitation that might be coming from the Chart Engine itself / or our Plugin's end.

Would it be possible for us to take a remote look at the back-end setup of your Table and the Form, as well as the Chart, how you configured them on your Site - then we can try to reproduce a similar setup on our end to confirm if it might be a bug?

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And point me to the Chart ID, please.

Thank you.

 Hi Kirstie,

Thank you so much for all your patience and cooperation on this issue.

Once again i wish to apologise for all the waiting time.

-

I found what the cause is for that value on the series showing up as a much higher number than you expected.

When i inspect the Chart, i notice you have chosen the first column as the String, of course, but for the second field you have chosen the "Entry ID" field.

That is the most crucial detail in this case.

When you activate "Chart Grouping" feature in our Plugin, it is not just counting how many times the same value of a String repeats, but it actually takes the numerical Column you chose as the second one for the Pie;

And it simply adds up, taking each row of the "Entry ID".

So with that in mind, now it makes sense that it is that huge number, let's just take a look at the first few cells of the Entry ID, that starts with 528, 527, 524 and so on.

And right away you can see when we start adding these up, it will be a much higher number than we want.

But i understand what you wish to achieve, so here is a workaround to get the actual number, how many times each unique value 'choice' repeats in your Form.

-

There can be two ways to achieve this, but in both methods, you need to add a new numeric "COUNT" column, which will serve just to add "1" as the default value for each row -  this way when you use it with "Chart Grouping", you will achieve an actual count, how many time each unique value repeats.

1. You can either add a hidden Field on your Form - and just have it always be as "1" as pre-populated Numeric Value.

Then add this in your Chart as the second field, instead of the "Entry ID" and you will achieve your goal.

-

Now, i tried doing this on your Form, i made a duplicate Table for testing;

But for example, if i add a "hidden" custom Field, and have it as custom predefined value of "1", this works only for future submissions - i can't get it to somehow 'auto populate' previously entered submissions

So if we try it this way - now on your existing submissions it does not populate, so we can't use it in your Chart.

But see if you can somehow get your source Form to auto-populate all the existing( and future) fields to always have "1" as the value in any Field;

Then you can use this Field in your chart for "count".

I will also show you other examples we have of this logic, how you can use the "Chart Grouping" with a pre-populated "1" value in a field to achieve your goal.

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.

-

We solve this by adding 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 :

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

This is the linked table :

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,

and here is an example with a Bar chart

Now, the Gravity Form integration, that is not available in the Lite wpDataTables;

You would need to switch to our Premium Plugin, and you also need full Gravity Forms,  then also you need our Gravity Forms integration Add-on,  to be able to achieve this exact example;

but you can check with Forminator Support, if they can help you to somehow auto-populate all the existing Submissions ( and future submissions)  to a hidden numeric Field which will always be "1" as the cell value;

so that you can use this logic as i shown in the example.

2. Or, in our Plugin's Table, if you would switch to Premium, you could add a Formula Field - and just have it be "1" in the Formula.

That way you will get the same result, without having to do anything on the Source Form.

If you wish to get the Formula Column Feature, that is not available in our Lite Plugin - for that you would need to switch to the Premium Plugin wpDataTables.

If you wish to try out the full/premium features, you can try premium 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)

You can also compare all the features between Lite and Premium, in the Dashboard, in "Lite vs Premium" section of our Plugin.

Let me know if you have any additional questions.