2. Create a chart from that table a select "Follow table filtering" option
3. Use the filters on the table and check how the chart takes the data of the current page only...
I don't know what kind of logic is that, but the common sense tolds me that if I use some chart responding to datatable filters, the charts will reflect data from all rows. What is the practical use of add some chart that gets the data from 20 rows the current page only?
Please, we purchase the plugin with that expectation. Charts must reflect the data of all rows that the user filter, not only the current page. Thats not usable. At least add it as an option.
Yes. Unfortunately, this is the current limitation when enabling the 'follow table filtering" in charts.
In that case, the chart only sees the first page of the table's pagination.
More details on how the charts currently load rows:
The charts are being created based on tables. If the table is server-side enabled, then only the rows shown in the table will be loaded on the chart.
If the table is non-server-side, the chart will load all the rows, unless we enable "Follow table filtering" with the table on the same page.
Basically, if you have a Manual table; they have automatically server-side enabled, we can't disable it.
So you would have to make another SQL Query based table, to pull data out of the Manual Table;
then you have to disable server-side processing for it;
and disable "Follow table filtering" - then the chart will load all rows ( if needed).
So, for server side tables, we currently don't have a valid solution to show all rows when filtering the chart other than hitting "show all rows", but we realize that isn't valid for very large tables due to the performance impact.
You can make a future improvement suggestion if you wish.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Hi there,
Reproduce
1. Create any table (posts)
2. Create a chart from that table a select "Follow table filtering" option
3. Use the filters on the table and check how the chart takes the data of the current page only...
I don't know what kind of logic is that, but the common sense tolds me that if I use some chart responding to datatable filters, the charts will reflect data from all rows. What is the practical use of add some chart that gets the data from 20 rows the current page only?
Please, we purchase the plugin with that expectation. Charts must reflect the data of all rows that the user filter, not only the current page. Thats not usable. At least add it as an option.
Hi Nicolas,
Yes. Unfortunately, this is the current limitation when enabling the 'follow table filtering" in charts.
In that case, the chart only sees the first page of the table's pagination.
More details on how the charts currently load rows:
The charts are being created based on tables. If the table is server-side enabled, then only the rows shown in the table will be loaded on the chart.
If the table is non-server-side, the chart will load all the rows, unless we enable "Follow table filtering" with the table on the same page.
Basically, if you have a Manual table; they have automatically server-side enabled, we can't disable it.
So you would have to make another SQL Query based table, to pull data out of the Manual Table;
then you have to disable server-side processing for it;
and disable "Follow table filtering" - then the chart will load all rows ( if needed).
So, for server side tables, we currently don't have a valid solution to show all rows when filtering the chart other than hitting "show all rows", but we realize that isn't valid for very large tables due to the performance impact.
You can make a future improvement suggestion if you wish.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[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