I can't find a way to chart data coming from several tables.
I have front end, user edits own data tables.
I've split my data across several tables to keep it organised and minimise the database calls. And I can chart each one individually,
But charts only allows data to be gathered from a single table. So I cant chart data sourced from multiple tables. So I thought I would collect the relevant data into one table and chart that. But I cant seem to achieve it.
There are just 3 integer fields in each table, and I just want to chart the average of each column - so just 3 numbers from 7 tables.
I got the "average" shortcodes from each table and column, but parsing the shortcodes into another table creates a string, not an integer, so I cant chart that table either.
Is there any way I can collate the numbers I need into one table, as integers, so I can chart it?
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You could only create a new SQL Query based table, that would pull the data from all other tables into one, and then create a new chart from that data table.
I can't find a way to chart data coming from several tables.
I have front end, user edits own data tables.
I've split my data across several tables to keep it organised and minimise the database calls. And I can chart each one individually,
But charts only allows data to be gathered from a single table. So I cant chart data sourced from multiple tables. So I thought I would collect the relevant data into one table and chart that. But I cant seem to achieve it.
There are just 3 integer fields in each table, and I just want to chart the average of each column - so just 3 numbers from 7 tables.
I got the "average" shortcodes from each table and column, but parsing the shortcodes into another table creates a string, not an integer, so I cant chart that table either.
Is there any way I can collate the numbers I need into one table, as integers, so I can chart it?
AJ
Hello Andrew
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You could only create a new SQL Query based table, that would pull the data from all other tables into one, and then create a new chart from that data table.
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