I can't for the life of me make a stupid bar chart. I have 4 pieces of data (acreage) broken down into 4 columns. See attached.
When I plot them they are all grouped under (250) which I assume is the average but why the hell would I want them grouped there? I want them in their own columns, their own colors, summed up. Please help. I'm sorry I'm so frustrated by this.
Unfortunately, no. Pivot would only be possible with SQL query tables, and it would have to be done in the database; then a view would have to be created, so wpDataTables can display the data from that view.
Unfortunately, pulling data from Gravity Forms tables in the database is very hard. That's why we have the integration add-on. If you know your way around SQL, you could probably be able to get all info from the forms, but I cannot help you with that because writing custom queries isn't included in the provided support for the plugin.
I can't for the life of me make a stupid bar chart. I have 4 pieces of data (acreage) broken down into 4 columns. See attached.
When I plot them they are all grouped under (250) which I assume is the average but why the hell would I want them grouped there? I want them in their own columns, their own colors, summed up. Please help. I'm sorry I'm so frustrated by this.
Hello George
Thank you for your purchase.
The first column is saved as the X axis, so that's what you see on the chart.
If you need to create a chart that'd look like this:
You would need to change the structure of the table to this:
I hope that helps.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
That helps, but the data comes from the Gravity Form connector so I can't alter the source table. Can I pivot the table using wpDataTables?
I see George
Unfortunately, no. Pivot would only be possible with SQL query tables, and it would have to be done in the database; then a view would have to be created, so wpDataTables can display the data from that view.
Unfortunately, pulling data from Gravity Forms tables in the database is very hard. That's why we have the integration add-on. If you know your way around SQL, you could probably be able to get all info from the forms, but I cannot help you with that because writing custom queries isn't included in the provided support for the plugin.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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