I am trying to use the column grouping in wpdatatables lite but it doesn't work, Is this only applicable to the PRO version?
Also I want to know if there is anyway I can add characters by using the superscript and sub script function as title because I want the title of my column to carry gaseous symbols so instead of having CO2 as the symbol, I should be able to write it properly with the "2" as a subscript.
Lastly, for charts , Is there a way I can distinguish 2 different charts that have similar name but different properties and data i.e If a company have 2 different gaseous data for their 2 different machines, How can I show the variation of the company machines based on Chart?
Grouping feature is enabled in lite version and should work if you enable it on column that have repeatable data like car name in Attach1.
Easiest way to do this would be to use HTML entities instead of character itself so instead of CO2 you enter CO₂ You can find more information about it here, and see the final result in Attach2
Best way to achieve this in my opinion would be to have all the data in one table and then create two charts based on that table and place it along with a table on same page. In the chart wizard turn on "Follow table filtering" feature which will allow automatically update the charts based on table filtering. This way when you filter the table based on desired feature or data you will have two charts that will show relevant data.
For more information about all these features please visit our - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
Thanks for your reply, I noticed that for Column to work on wpdatatables, You need to use the Excel format upload. I will like to confirm if I use Formidable forms or Gravity Form integration, Will I be able to group columns?
Grouping feature is limited to the non server side tables so you can use it on all table source as long as the server side is turned off. MySQL based tables, and Gravity based tables have an option to turn on server- side processing nad manually created ones (also MySQL based) have server-side turned on and in this cases grouping is not possible.
You can find more information about server-side processing in our - Documentation
Unfortunately there is no option to do this with plugin itself. Easiest way would be to create one more column in data source which will contain both properties compiled and just hide that column in the table but use it in the chart
Thanks for your response, can the Property compilation for the new column be done automatically? If yes, How can I do this? If no, Can it be run in the code?
Hi, I just purchased the wpdatatables report builder, I will like to know if I can embed a chart in the report e.g, I created a chart and I'll like to make it appear in a report.
I am trying to use the column grouping in wpdatatables lite but it doesn't work, Is this only applicable to the PRO version?
Also I want to know if there is anyway I can add characters by using the superscript and sub script function as title because I want the title of my column to carry gaseous symbols so instead of having CO2 as the symbol, I should be able to write it properly with the "2" as a subscript.
Lastly, for charts , Is there a way I can distinguish 2 different charts that have similar name but different properties and data i.e If a company have 2 different gaseous data for their 2 different machines, How can I show the variation of the company machines based on Chart?
Hi Abimifoluwa,
Thank you for your inquire.
Grouping feature is enabled in lite version and should work if you enable it on column that have repeatable data like car name in Attach1.
Easiest way to do this would be to use HTML entities instead of character itself so instead of CO2 you enter CO₂ You can find more information about it here, and see the final result in Attach2
Best way to achieve this in my opinion would be to have all the data in one table and then create two charts based on that table and place it along with a table on same page. In the chart wizard turn on "Follow table filtering" feature which will allow automatically update the charts based on table filtering. This way when you filter the table based on desired feature or data you will have two charts that will show relevant data.
For more information about all these features please visit our - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo
Thanks for your reply, I noticed that for Column to work on wpdatatables, You need to use the Excel format upload. I will like to confirm if I use Formidable forms or Gravity Form integration, Will I be able to group columns?
Hi Abimifoluwa,
Grouping feature is limited to the non server side tables so you can use it on all table source as long as the server side is turned off. MySQL based tables, and Gravity based tables have an option to turn on server- side processing nad manually created ones (also MySQL based) have server-side turned on and in this cases grouping is not possible.
You can find more information about server-side processing in our - Documentation
This has been noted and fixed using Google Spreadsheet as a medium of Updating the table.
My challenge now is the Chart.
I will like to know if in anyway I can use 2 properties in naming a string variable of a chart.
For Example, If I have table that carries "Name of Employee", "Department" with other data like "Total Input", "No of time at work" etc.
Can i plot my graph in such a way that "Name of Employee (Department)" will be shown in the X axis against the other Variables?
i.e
Name of Employee: John
Department: Kitchen
Total Input: 3
No of time at Work: 7
Now the graph will plot "John (Kitchen)" against "Total Input" and "No of time at work".
I hope you understand this?
Hi,
Unfortunately there is no option to do this with plugin itself. Easiest way would be to create one more column in data source which will contain both properties compiled and just hide that column in the table but use it in the chart
Thanks for your response, can the Property compilation for the new column be done automatically? If yes, How can I do this? If no, Can it be run in the code?
Hi,
It could be done with hooks but it would be easier to do it on Google Spreadsheet side. I take a quick search and it look like it could be done - LINK
Hi, I just purchased the wpdatatables report builder, I will like to know if I can embed a chart in the report e.g, I created a chart and I'll like to make it appear in a report.
Hi,
Unfortunately there is no option to include the chats in Report Builder reports at this moment.