We have wpDataTables and Powerful Filters installed on a site that we are developing, and we are hoping to replicate the following functionality that is currently available using custom logic to take data entered into a Joomla CMS that we assume is stored in CSV files and combine and perform calculations on that data to produce a chart and table using the High Charts JS library. We would like to know if it is possible to replicate this functionality with wpDataTables.
This is how the current functionality works: A user can choose from a number of products and can select more than one product.
After choosing the product(s), they select a high or low value or a calculated average value, and whether to display the values on a weekly or monthly basis and what units the data is displayed in. The units are calculated using conversions to convert the base values to $ per tonne, metric tonne or gross tonne. Once the filters are applied, the user clicks the view chart button. A chart and table are then displayed.
As with any chart in wpDataTables, the user can then click on the series label to toggle the series on or off.
We are wondering how we might replicate this functionality with wpDataTables and what would be required.
We have tried Powerful Filters, but we have struggled because it filters amongst rows but cannot filter which columns are displayed. Is there a way for a front-end user to interactively filter which data series are displayed without being able to edit the underlying data?
Thank you in advance,
With the current built-in capabilities of our plugin, it is not possible to filter column visibility like that,
if i understood correctly, you don't only need to filter by cell values in rows, ( as you pointed out, that would be possible with Powerful Filters and "hide table before filtering" option),
but you also need to have the capability to filter if some columns will be included or not,
and that should also show or hide columns for charts as well as tables, based on what user selects on the front-end?
I am sorry to disappoint you,
at this time we don't have any built-in solution to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.
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.
-
If you have coding skills and wish to try to make a custom solution now,
Hello,
We have wpDataTables and Powerful Filters installed on a site that we are developing, and we are hoping to replicate the following functionality that is currently available using custom logic to take data entered into a Joomla CMS that we assume is stored in CSV files and combine and perform calculations on that data to produce a chart and table using the High Charts JS library. We would like to know if it is possible to replicate this functionality with wpDataTables. This is how the current functionality works: A user can choose from a number of products and can select more than one product.
After choosing the product(s), they select a high or low value or a calculated average value, and whether to display the values on a weekly or monthly basis and what units the data is displayed in. The units are calculated using conversions to convert the base values to $ per tonne, metric tonne or gross tonne. Once the filters are applied, the user clicks the view chart button. A chart and table are then displayed.
As with any chart in wpDataTables, the user can then click on the series label to toggle the series on or off.
We are wondering how we might replicate this functionality with wpDataTables and what would be required. We have tried Powerful Filters, but we have struggled because it filters amongst rows but cannot filter which columns are displayed. Is there a way for a front-end user to interactively filter which data series are displayed without being able to edit the underlying data? Thank you in advance,
Kevin Anderson
Hi, Kevin Anderson
Sorry for the delay
-
With the current built-in capabilities of our plugin, it is not possible to filter column visibility like that,
if i understood correctly, you don't only need to filter by cell values in rows, ( as you pointed out, that would be possible with Powerful Filters and "hide table before filtering" option),
but you also need to have the capability to filter if some columns will be included or not,
and that should also show or hide columns for charts as well as tables, based on what user selects on the front-end?
I am sorry to disappoint you,
at this time we don't have any built-in solution to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.
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.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything like this yet)
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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