I'd like to create a series of summary charts that are take criteria from dropdowns or other table tools. How can I accomplish this? My thought was to create a table and allow filtering however i only want my charts to show summary data (ie in sql sum(xyx)) of the data based on what is selected.
Filtering charts would only work if you add both the chart and the table on the same page. You would be able to add a formula column which would calculate the sum of other columns (column1+column2+column3) and then plot that column on the chart.
I'm not sure if that's what you want to achieve, though.
The charts look for data within cells, and each row is plotted on a chart as a separate data string. So, adding calculation functions to the chart is not possible.
You could, however, create a MySQL query-based table, where you would perform these calculations through the query, so the sum is in one row, in multiple columns. That way, you'd calculate the data from table1, in table2 and use table2 for displaying that data in a chart.
I never attempted to do this, but I suppose that it is possible.
Thanks Aleksander. I think I'll create 2 tables, a summary and a details table. The Summary will have a url link in it to a different page that will call on the details of whichever you clicked on.
Hi,
I'd like to create a series of summary charts that are take criteria from dropdowns or other table tools. How can I accomplish this? My thought was to create a table and allow filtering however i only want my charts to show summary data (ie in sql sum(xyx)) of the data based on what is selected.
Hello Andrew
Filtering charts would only work if you add both the chart and the table on the same page. You would be able to add a formula column which would calculate the sum of other columns (column1+column2+column3) and then plot that column on the chart.
I'm not sure if that's what you want to achieve, though.
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
Ah I want to do the opposite, I want to have a sum of all data in a given column (meeting the filtered criteria), not the sum of col 1, col2, etc.
In sql I might use a subquery to do this.
select sum(col1) as thesum from (
select col1 from tablename where criteriaCol = <column i can filter in table>
)
I don't see a way you could do this, Andrew.
The charts look for data within cells, and each row is plotted on a chart as a separate data string. So, adding calculation functions to the chart is not possible.
You could, however, create a MySQL query-based table, where you would perform these calculations through the query, so the sum is in one row, in multiple columns. That way, you'd calculate the data from table1, in table2 and use table2 for displaying that data in a chart.
I never attempted to do this, but I suppose that it is possible.
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
Thanks Aleksander. I think I'll create 2 tables, a summary and a details table. The Summary will have a url link in it to a different page that will call on the details of whichever you clicked on.
Thanks!
You're welcome, Andrew.
Glad I could be of assistance (if I even was of any lol
)
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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