I use placeholders to import the sum of 4 numeric columns from Table A, to Table B using the string (otherwise placeholder does not function). This functions nicely, and I get table B drawn from these values (4 columns). However, when I try to display the columns of Table B (constructed with placeholders) in a bar chart, it does not work as bar graph could have only one column with strings for labels others must be number columns. If I convert the string columns to numeric, then the placeholders don't work.
Unfortunately, that's the drawback of using placeholders. They only work in string-type columns, and you can't use more than one string-type column to create a chart.
If you have manual tables, you can copy the MySQL Table Name For Editing from the Editing tab above the table, and create table B as an SQL query based table. That would allow you to import the values as integers, and use them normally to create a chart.
Thank you Aleksandar. I followed your advise and created table B as a MySQL query table from table A. I got nicely the SUMS of the columns in one row. Any chance that I enter the second and third rows MANUALLY for e.g comparison of the figures from past years? In other words, could it be possible that a table based on MySQL query could have mixed rows: the first one generated by the MySQL query and the other rows generated manually? Or any chance that only one cell of a table receives the data using MySQL query while other cells get written manually?
That's something I too would like to see in wpDataTables, but turns out to be a much more demanding task than expected.
Our developers will work on this in the future, but at the moment, in order to create a new column in the table, you need to add it in the database tables it is pulled from.
I use placeholders to import the sum of 4 numeric columns from Table A, to Table B using the string (otherwise placeholder does not function). This functions nicely, and I get table B drawn from these values (4 columns). However, when I try to display the columns of Table B (constructed with placeholders) in a bar chart, it does not work as bar graph could have only one column with strings for labels others must be number columns. If I convert the string columns to numeric, then the placeholders don't work.
Hello Aydin
Unfortunately, that's the drawback of using placeholders. They only work in string-type columns, and you can't use more than one string-type column to create a chart.
If you have manual tables, you can copy the MySQL Table Name For Editing from the Editing tab above the table, and create table B as an SQL query based table. That would allow you to import the values as integers, and use them normally to create a chart.
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
Thank you Aleksandar. I followed your advise and created table B as a MySQL query table from table A. I got nicely the SUMS of the columns in one row. Any chance that I enter the second and third rows MANUALLY for e.g comparison of the figures from past years? In other words, could it be possible that a table based on MySQL query could have mixed rows: the first one generated by the MySQL query and the other rows generated manually? Or any chance that only one cell of a table receives the data using MySQL query while other cells get written manually?
Sorry, Aydin, but not yet.
That's something I too would like to see in wpDataTables, but turns out to be a much more demanding task than expected.
Our developers will work on this in the future, but at the moment, in order to create a new column in the table, you need to add it in the database tables it is pulled from.
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