I've created a pie chart linking to some info from a table I imported and once I perform a search on the table the pie chart isn't displaying the weights of the results correctly. As you can see there are 8 options and they should all hold equal weight. Is there a way to do this? Ideally I would only like to select one string for the pie chart however that isn't possible. Currently the columns being used in the chart are the Status of Request Column and the wdt_ID column.
The 'follow table filtering' was already enabled. The chart was just displaying the results incorrectly as there are only 8 entries, each with 1 type of status so each sector of the pie chart should be 12.5%. Is it because i am using the wdt_ID column along with the status of request column in the chart?
wdt_ID column is an auto-increment column, so each new row has its own ID.
If you need to display the status types in percentages, you need to create a new integer column that will have the default value set to "1", and include that instead of wdt_ID. Then, you can enable "Grouping" in chart preview section (in the chart creation wizard), and you will see the percentage of status types correctly displayed.
This is very helpful, and has semi solved my issue, thank you!
One more question. For some of the fields in my form they are left blank when an entry is made as they do not need to be filled out. i.e. if an order is being made to a hotel, a field named: Hotel Name needs to be filled in however if the order is not being made to a hotel this field will not appear and is left blank. When I go to make a chart displaying the hotels we work with, as I am using the integer column with default value 1, the entries where the hotel name is left blank are also included in the chart. Is there a way around this? I.e creating a column that will only count entries if there is something in the cell and it is not blank.
Unfortunately, we can't skip any data from the table selectively. It's a feature already requested a few times, so our developers will work on it for one of our future updates.
Until then, unfortunately, there's no built-in option to skip null values.
That's a shame. Unfortunately I'm also encountering some other issues with the tables and charts. When adding a table to my page it's corresponding charts disappear. Once it is removed they reappear. I've removed the option for no entries to appear before a search is made so it isn't to do with that. I was wondering if you'd had anyone else mention this issue.
Along with this I've been receiving an error code when editing my tables followed by a message stating there's been a fatal error. Thankfully I don't think it has caused any damage to the site when I have received these errors however it will not let me back into the table and I have to start the table over again.
Below you can see one of the error codes I received earlier today.
An error of type E_ERROR was caused in line 3183 of the file /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php. Error message: Uncaught Error: Call to a member function setFilterType() on boolean in /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php:3183 Stack trace: #0 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(3160): WPDataTable->prepareRenderingRules(Array) #1 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(3896): WPDataTable->fillFromData(Object(stdClass), Array) #2 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php(97): WPDataTable::loadWpDataTable(1, NULL) #3 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(575): WDTConfigController::loadTableConfig(1) #4 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(645): wdtEdit() #5 /home/nw4tn1sz8uh6/public_html/wp-includes/class-wp-hook.php(288): wdtConstructor('') #6 /home/nw4tn1sz8uh6/public_html/wp-includes/class-wp-hook.php(
We've had issues like these in older versions of the plugin, but those were resolved with 3.1. Now, with the current version (3.2) you shouldn't be facing these issues.
I'm sorry I wasn't able to help you resolve this, and I saw your refund request ticket just now. If you wish to proceed with troubleshooting, we can extend the refund period for a few days, but I can totally understand if you don't want to do that.
Hi,
I've created a pie chart linking to some info from a table I imported and once I perform a search on the table the pie chart isn't displaying the weights of the results correctly. As you can see there are 8 options and they should all hold equal weight. Is there a way to do this? Ideally I would only like to select one string for the pie chart however that isn't possible. Currently the columns being used in the chart are the Status of Request Column and the wdt_ID column.
Thanks
Hello Zak
If I understood you correctly, you want the chart to display what's currently displayed in the table?
If that's true, you need to edit the chart, and enable "Follow Table Filtering".
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,
The 'follow table filtering' was already enabled. The chart was just displaying the results incorrectly as there are only 8 entries, each with 1 type of status so each sector of the pie chart should be 12.5%. Is it because i am using the wdt_ID column along with the status of request column in the chart?
That's it, Zak
wdt_ID column is an auto-increment column, so each new row has its own ID.
If you need to display the status types in percentages, you need to create a new integer column that will have the default value set to "1", and include that instead of wdt_ID. Then, you can enable "Grouping" in chart preview section (in the chart creation wizard), and you will see the percentage of status types correctly displayed.
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,
This is very helpful, and has semi solved my issue, thank you!
One more question. For some of the fields in my form they are left blank when an entry is made as they do not need to be filled out. i.e. if an order is being made to a hotel, a field named: Hotel Name needs to be filled in however if the order is not being made to a hotel this field will not appear and is left blank. When I go to make a chart displaying the hotels we work with, as I am using the integer column with default value 1, the entries where the hotel name is left blank are also included in the chart. Is there a way around this? I.e creating a column that will only count entries if there is something in the cell and it is not blank.
Thanks
Zak
Hello Zak
Unfortunately, we can't skip any data from the table selectively. It's a feature already requested a few times, so our developers will work on it for one of our future updates.
Until then, unfortunately, there's no built-in option to skip null values.
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's a shame. Unfortunately I'm also encountering some other issues with the tables and charts. When adding a table to my page it's corresponding charts disappear. Once it is removed they reappear. I've removed the option for no entries to appear before a search is made so it isn't to do with that. I was wondering if you'd had anyone else mention this issue.
Along with this I've been receiving an error code when editing my tables followed by a message stating there's been a fatal error. Thankfully I don't think it has caused any damage to the site when I have received these errors however it will not let me back into the table and I have to start the table over again.
Below you can see one of the error codes I received earlier today.
--------------------------------------------------------------------------------------------------------------------
An error of type E_ERROR was caused in line 3183 of the file
/home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php.
Error message: Uncaught Error: Call to a member function
setFilterType() on boolean in
/home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php:3183
Stack trace:
#0 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(3160):
WPDataTable->prepareRenderingRules(Array)
#1 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wpdatatable.php(3896):
WPDataTable->fillFromData(Object(stdClass), Array)
#2 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php(97):
WPDataTable::loadWpDataTable(1, NULL)
#3 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(575):
WDTConfigController::loadTableConfig(1)
#4 /home/nw4tn1sz8uh6/public_html/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(645):
wdtEdit()
#5 /home/nw4tn1sz8uh6/public_html/wp-includes/class-wp-hook.php(288):
wdtConstructor('')
#6 /home/nw4tn1sz8uh6/public_html/wp-includes/class-wp-hook.php(
--------------------------------------------------------------------------------------------------------------------
Please let me know if there's something I can do on my end.
Regards
Zak
We've had issues like these in older versions of the plugin, but those were resolved with 3.1. Now, with the current version (3.2) you shouldn't be facing these issues.
I'm sorry I wasn't able to help you resolve this, and I saw your refund request ticket just now. If you wish to proceed with troubleshooting, we can extend the refund period for a few days, but I can totally understand if you don't want to do that.
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,
Thank you for your prompt responses.
Unfortunately I think we'd still like to go ahead with the refund.
Many thanks
Zak
I understand, Zak.
Just file for a refund in our store as indicated in the other ticket, and that's it. You'll be refunded in 5 - 7 business days
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,
As far as I'm aware I filed for a refund a couple of days ago.
Can you just confirm that has gone through and been received.
Regards
Zak
Unfortunately, I don't have an insight into pending refund requests.
If you don't receive your money after 7 days please reach out to me, and I'll contact our reseller, Paddle, who handles all our payments and refunds.
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