Hey Aleksandar, Thanks for the replay. I have been playing around with the different (table - chart) variations. And I totally get that if you attempt something like this then all charts need to have the same Data Table in common. I have found that I can run two charts from the same table, but then I have to use row filtering in the chart wizard to separate data for the specific to the chart. Once I do that the 'Follow table filtering' checkbox grays out and is no longer available. Is there another way to use a larger data table that contains enough data for two different charts and then apply the row filtering in a way that will not turn off the 'Following table filtering' feature?
You're right - "Follow table filtering" will work for the visible rows, and if you filter the table, but the generated chart will be generated based on what is currently displayed in the table on front-end.
I'd recommend updating to the latest version of wpDataTables (3.0.1), but that will not resolve the issue, and the range picker would not work (we have a bug in there somewhere). Our developers are working on resolving that, but until then I don't have any code to send that would fix the issue for you.
What you can do, in this particular case, though, would be to create an SQL query based table where you would add a WHERE condition, to pull only those rows.
For example, if in the "Name" column you have "Mike", "Dave", "John", "Lucy", "Mary", and you only want rows from a few names, you'd create a query like:
SELECT * FROM myTable
WHERE name = 'Mike' and name = 'John' and name = 'Mary'
That would create a table showing only those 3 rows, and then you would be able to create a chart from that table. Filtering from the original table would not work on that chart, though.
Hey if I have multiple charts on one page is there a way to have all of them filter/controlled with one filter widget?
Hello Kyle
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Table filters work only on their tables, and the charts created from that table. There's no way to use one "master" filter for all charts.
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
Hey Aleksandar, Thanks for the replay. I have been playing around with the different (table - chart) variations. And I totally get that if you attempt something like this then all charts need to have the same Data Table in common. I have found that I can run two charts from the same table, but then I have to use row filtering in the chart wizard to separate data for the specific to the chart. Once I do that the 'Follow table filtering' checkbox grays out and is no longer available. Is there another way to use a larger data table that contains enough data for two different charts and then apply the row filtering in a way that will not turn off the 'Following table filtering' feature?
Hi again Kyle
You're right - "Follow table filtering" will work for the visible rows, and if you filter the table, but the generated chart will be generated based on what is currently displayed in the table on front-end.
I'd recommend updating to the latest version of wpDataTables (3.0.1), but that will not resolve the issue, and the range picker would not work (we have a bug in there somewhere). Our developers are working on resolving that, but until then I don't have any code to send that would fix the issue for you.
What you can do, in this particular case, though, would be to create an SQL query based table where you would add a WHERE condition, to pull only those rows.
For example, if in the "Name" column you have "Mike", "Dave", "John", "Lucy", "Mary", and you only want rows from a few names, you'd create a query like:
That would create a table showing only those 3 rows, and then you would be able to create a chart from that table. Filtering from the original table would not work on that chart, though.
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