I am just learning WPDataTables and so far really like it. But I do have one challenge I can't find an answer for. I am using the Gravity Forms integration with WPDataTables and trying to create a Radar Chart via Chart.js. The created table within WPDataTables has columns with the questions from a survey in Gravity Forms. The Users have a column heading and are listed in the rows. When the Radar Chart is created, the Series shown in the graph are automically the Questions.
But what I need is to have the Users be the Series.
Is there a way to do this in WPDataTables?
Can I transpose the columns and rows so that the Users are listed in the Series of the Radar Chart? Then each user (or average of the User's answers) will be shown in the Radar Chart.
Is there another way?
I thought about the possibility of using a MySQL query but I am very inexperienced in that area but very willing to learn if that is the solution.
Before I offer any specific reply, I'd like to see the table and the chart if at all possible.
Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
I am guessing that you created the table manually. In fact I was able to do the same thing. Cool! I am learning!
Is there a way to do this design (pivoting the data) on an automatic basis with server side processing. (I am expecting many hundreds of thousands of user survey entries) with the number of questions being either 5 or 30.
I created the table manually, and unfortunately there's no way of pivoting them any other way through the plugin. You may be able to do that if you import it straight into the database, and create a PIVOT table in PHPMyAdmin.
Hi,
I am just learning WPDataTables and so far really like it. But I do have one challenge I can't find an answer for. I am using the Gravity Forms integration with WPDataTables and trying to create a Radar Chart via Chart.js. The created table within WPDataTables has columns with the questions from a survey in Gravity Forms. The Users have a column heading and are listed in the rows. When the Radar Chart is created, the Series shown in the graph are automically the Questions.
But what I need is to have the Users be the Series.
Is there a way to do this in WPDataTables?
Can I transpose the columns and rows so that the Users are listed in the Series of the Radar Chart? Then each user (or average of the User's answers) will be shown in the Radar Chart.
Is there another way?
I thought about the possibility of using a MySQL query but I am very inexperienced in that area but very willing to learn if that is the solution.
Thank you! Roy Gill
Hello Roy.
Thank you for your purchase.
Before I offer any specific reply, I'd like to see the table and the chart if at all possible.
Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hello Roy.
I logged in and took a look at the chart and the table.
Unfortunately, the plugin works in a predefined logic and can't be changed. What can, however, be changed is the table.
I created a new table with the pivoted data, and created a new chart [wpdatachart id=4].
Please take a look and tell me if this is what you had in mind?
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi Aleksandar,
That is exactly what I had in mind! You are awesome!
How did you pivot the data? Is it something I can do? It looks like you used the manual process rather then the Gravity link.
Is the table adaptable to an increase in number of questions?
Thank you again!
Roy
Hi Aleksandar,
I am guessing that you created the table manually. In fact I was able to do the same thing. Cool! I am learning!
Is there a way to do this design (pivoting the data) on an automatic basis with server side processing. (I am expecting many hundreds of thousands of user survey entries) with the number of questions being either 5 or 30.
Thank you!
Roy
Hello again Roy.
You're welcome.
I created the table manually, and unfortunately there's no way of pivoting them any other way through the plugin. You may be able to do that if you import it straight into the database, and create a PIVOT table in PHPMyAdmin.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi Aleksandar,
I was hoping for better news but thank you! Also thank you for the idea of creating a pivot table in PHPMyAdmin. I am going to be learning so more!
Thank you again for all your help! Roy
You're welcome Roy.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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