I'm having some presentation issues when it comes to creating a table and presenting it as a chart - which could be beyond scope of the tool or I've got a fundamental problem how I'm grabbing the data.
Here's how the chart and table is looking from data pulled from the database (opposed to a linked file or simple table):
I'm currently working on getting the top left chart working first, then will have a process to fill in the rest. [see attached for reference]
I can't get the column titles to appear under each column/axis and there currently doesn't seem to be an option to display the values/labels without hovering over.
Any thoughts or assistance would be truly welcomed.
This is how Google Charts work. You can use Highcharts, and they'd display column names below each column in the chart. Similar to how it looks here.
If you don't want to use Highcharts, and you need to stay on Google Charts, you may need to use wpDataCharts callbacks.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API.
All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.
I think the problem is how the data/table is structured. At this point I'm thinking I need to create a 'group' classification for the categories and structure the data as a loop in Custom Fields so that the table gets all items under 'categories' (which will form the left column) and the associated value to the right. At this point that seems over-kill for such a simple solution so I'm looking into other plug-ins to handle simple charts that can bind directly to the field in WP. Your tool is PERFECT for my other requirements and am really pleased to be working with you guys :-)
The chart added to the link I shared before doesn't have any custom code applied that would render the column names below each column - it's a default setting of the column chart in Highcharts.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Here's the structure of the table needed to achieve the structure of the chart shown on our FAQ page:
So, there needs to be only 1 column in the table and all those labels below the columns in the chart are actually row values of that column from the table.
The desired appearance is not possible with table #7, as the chart engine can't read it and plot the data in that way without using the wpDataCharts callbacks.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API.
Unfortunately, using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.
Hi
I'm having some presentation issues when it comes to creating a table and presenting it as a chart - which could be beyond scope of the tool or I've got a fundamental problem how I'm grabbing the data.
Here's how the chart and table is looking from data pulled from the database (opposed to a linked file or simple table):
https://test.insuranceaum.com/conning-table-and-chart-sample/
What I need the end page to look like is this:
https://dev.camradata.com/InsuranceAUM/InsuranceAUM.aspx?firmId=127283
I'm currently working on getting the top left chart working first, then will have a process to fill in the rest. [see attached for reference]
I can't get the column titles to appear under each column/axis and there currently doesn't seem to be an option to display the values/labels without hovering over.
Any thoughts or assistance would be truly welcomed.
Cheers
Glenn
Hey Glenn
This is how Google Charts work. You can use Highcharts, and they'd display column names below each column in the chart. Similar to how it looks here.
If you don't want to use Highcharts, and you need to stay on Google Charts, you may need to use wpDataCharts callbacks.
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
Hi Aleksandar
I've just tried using Highcharts and have come to the same result as with Google Charts:
https://test.insuranceaum.com/conning-table-and-chart-sample/
I think the problem is how the data/table is structured. At this point I'm thinking I need to create a 'group' classification for the categories and structure the data as a loop in Custom Fields so that the table gets all items under 'categories' (which will form the left column) and the associated value to the right. At this point that seems over-kill for such a simple solution so I'm looking into other plug-ins to handle simple charts that can bind directly to the field in WP. Your tool is PERFECT for my other requirements and am really pleased to be working with you guys :-)
Thanks for all your help [yet again],
Glenn
Hey Glenn
The chart added to the link I shared before doesn't have any custom code applied that would render the column names below each column - it's a default setting of the column chart in Highcharts.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
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
Hey Glenn
This one's on me. Sorry.
Here's the structure of the table needed to achieve the structure of the chart shown on our FAQ page:
So, there needs to be only 1 column in the table and all those labels below the columns in the chart are actually row values of that column from the table.
The desired appearance is not possible with table #7, as the chart engine can't read it and plot the data in that way without using the wpDataCharts callbacks.
Unfortunately, using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.
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
That's quite alright, Glenn
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