I have integrated with Formidable Forms and now have a wpDataTables table. I am trying to create a stacked line graph from one record in the data table. The data table has multiple entries but I want a graph from only one of the entries. I have 12 revenue fields and 12 cost fields in each record in the table and want to show a stacked line graph similar to the one in the attachment. Can I do this with wpDataTables?
In this case I would suggest using Follow table filtering option and prefilter your table to display only the desired value. You can filter the table with placeholders and then hide the table from displaying on the page.
You can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.
If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:
[wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150".
If you need to hide the filters, a simple css like this would be enough:
And that's it. This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.
I have integrated with Formidable Forms and now have a wpDataTables table. I am trying to create a stacked line graph from one record in the data table. The data table has multiple entries but I want a graph from only one of the entries. I have 12 revenue fields and 12 cost fields in each record in the table and want to show a stacked line graph similar to the one in the attachment. Can I do this with wpDataTables?
Hi John
Thank you for reaching out to us.
In this case I would suggest using Follow table filtering option and prefilter your table to display only the desired value. You can filter the table with placeholders and then hide the table from displaying on the page.
You can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.
If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:
[wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150".
If you need to hide the filters, a simple css like this would be enough:
.wpdt-c .wpDataTables.wpDataTablesWrapper { display: none !important; }You can hide the table, leaving the filters above the chart like this:
<style> .wpdt-c .wpDataTablesWrapper table { display: none !important; } </style> [wpdatatable id=1] [wpdatachart id=1]And that's it. This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.