I'm trying to create a chart from a table that is filtered by default, but instead of showing the filtered rows from the table, the chart is instead using ALL the rows from the data source. How do I fix this?
In case it helps, here is the context: I have one data source that includes data from 5 different states. I then use that data source for five different tables, each filtering the rows by their state. Then, I want to create charts from each of those tables using the filtered tables. This data updates every month, so I can't just select the rows via the range picker since the states aren't always on the same row. The goal is that I will update the data source in the media library every month and it will automatically update all five tables and all five charts without having to do any other configurations. Is this possible?
If you're creating 5 different tables using the same source, you should have no issues displaying individual charts for each of these tables.
Please tell me how you're creating the tables?
Also, when you're creating the chart, there's an option you need to enable - "Follow table filtering". That will display the chart depending on the filtered values from the table.
Thank you for responding, and sorry it's taking me so long to get back to you. I did see the "Follow table filtering" option, but as the tooltip indicates for that option, that only works when the table and the chart are displayed on the same page. The pages that show these charts do not need the corresponding tables; is my only option to insert these tables and use CSS or JS to hide them from the user? Seems like an awkward workaround.
For that feature to work, unfortunately, at the moment you do need to post both the table and the chart on the page, and if you don't need the table to be displayed, then we can hide it with CSS.
Unfortunately, that is the only workaround that'd help you out in this case.
I'm trying to create a chart from a table that is filtered by default, but instead of showing the filtered rows from the table, the chart is instead using ALL the rows from the data source. How do I fix this?
In case it helps, here is the context: I have one data source that includes data from 5 different states. I then use that data source for five different tables, each filtering the rows by their state. Then, I want to create charts from each of those tables using the filtered tables. This data updates every month, so I can't just select the rows via the range picker since the states aren't always on the same row. The goal is that I will update the data source in the media library every month and it will automatically update all five tables and all five charts without having to do any other configurations. Is this possible?
Hello jerundle
Thank you for your purchase.
If you're creating 5 different tables using the same source, you should have no issues displaying individual charts for each of these tables.
Please tell me how you're creating the tables?
Also, when you're creating the chart, there's an option you need to enable - "Follow table filtering". That will display the chart depending on the filtered values from the table.
Best regards.
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
Alekdandar,
Thank you for responding, and sorry it's taking me so long to get back to you. I did see the "Follow table filtering" option, but as the tooltip indicates for that option, that only works when the table and the chart are displayed on the same page. The pages that show these charts do not need the corresponding tables; is my only option to insert these tables and use CSS or JS to hide them from the user? Seems like an awkward workaround.
Hi again jerundle.
For that feature to work, unfortunately, at the moment you do need to post both the table and the chart on the page, and if you don't need the table to be displayed, then we can hide it with CSS.
Unfortunately, that is the only workaround that'd help you out in this case.
Best regards.
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
Understood. Thank you, Aleksandar.
You're welcome jerundle.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
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