I want to create a web page with multiple charts from the same table and give the ability, on the frontend, to change the "data range filter" in the charts.
I don't want to show the charts AND the table where i will pick the data.
It will be nice if the user can pick (for example): latest N points or latest 7 days., month (or whatever) in the charts...
You can take a look at our documentation about all the available filters in our plugin there you can see that we have a date picker filters.
You will need to search the table in order for chart to be searched also but you will need to setup this in the chart wizard by enabling the Follow table filtering option.
The table and the chart ( related to that table) must be on the same page, but you can hide the table with some small Java Script that will run on that page.
Unfortunately latest 7 days, months is something that is not possible to achieve with the plugin built in features at the moment, only the basic datepicker is available.
In this case the table will remain hidden and only charts will be visible.
The filters for the table will be visible and there you can filter the table( which stays hidden) and the charts will change it based on the filter that you choose.
When you make a table from the first option it will take some time until the changes in the file are applied in the table.
If you make a table from the third option, changes in the files are not be applied to our tables and you will need to make changes through our plugin, because that tables are then editable.
For example the tables created from Google spreadsheet have a limitation which you can see in our documentation:
There is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTable.
So the update for other tables ( like your example CSV) will take up to 3-4 minutes or faster ( this also depends on the server) but there is no workaround to manual change the time of the update.
Hi
I'm using your sandbox for understand how your plugin works (http://sandbox.wpdatatables.com/tables-and-charts-wordpress-demo/)
I want to create a web page with multiple charts from the same table and give the ability, on the frontend, to change the "data range filter" in the charts.
I don't want to show the charts AND the table where i will pick the data.
It will be nice if the user can pick (for example): latest N points or latest 7 days., month (or whatever) in the charts...
How can i do that? Is it possible?
Thanks
HI andrea,
Thank you for your inquire.
You can take a look at our documentation about all the available filters in our plugin there you can see that we have a date picker filters.
You will need to search the table in order for chart to be searched also but you will need to setup this in the chart wizard by enabling the Follow table filtering option.
Best regards.
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
Thanks for your support.
Should the table stay in the same page with charts?
I don't want to see the table, only the charts.
But I want something near the charts where i can pick (for example): latest N points or latest 7 days, last month (or whatever)...
HI andrea,
The table and the chart ( related to that table) must be on the same page, but you can hide the table with some small Java Script that will run on that page.
Unfortunately latest 7 days, months is something that is not possible to achieve with the plugin built in features at the moment, only the basic datepicker is available.
Best regards.
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
ok cool!
so i can have the filterings and options of a table object (without showing data) near the charts object?
Could you post the java code?
regards
HI andrea,
Ok first thing you need to do is to Enable follow table filtering in the chart settings. ( attachment 1)
Then go to TABLE settings and check Filter in form option. ( attachment 2)
Then paste the shortcodes for the table and the chart on the same page.
After that use this script on the page
In this case the table will remain hidden and only charts will be visible.
The filters for the table will be visible and there you can filter the table( which stays hidden) and the charts will change it based on the filter that you choose.
Best regards.
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
Thanks! It works great!
I wrote a little bash script that update and append data in a csv file.
After I created a datatable it will not update with latest data. How can i fix it?
Regards
HI andrea,
Can you please tell me which option in the table wizard did you choose for creating this table.
The 1st one ( Create a table linked to an existing data source) or the 3rd one ( Create a table by importing data from data source) ?
Best regards.
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
Both.
HI andrea,
When you make a table from the first option it will take some time until the changes in the file are applied in the table.
If you make a table from the third option, changes in the files are not be applied to our tables and you will need to make changes through our plugin, because that tables are then editable.
Best regards.
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
Ah ok!
Can i chage the frequency update from the first option?
regards
HI andrea,
Unfortunately no.
For example the tables created from Google spreadsheet have a limitation which you can see in our documentation:
There is a cache on the Google side, so when you update the table it might take up to 5-15 minutes to be reflected in wpDataTable.
So the update for other tables ( like your example CSV) will take up to 3-4 minutes or faster ( this also depends on the server) but there is no workaround to manual change the time of the update.
Best regards.
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