Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
Also, if at all possible, could you also provide the PHPMyAdmin (database) credentials, so I can see the table in the database as well?
Please make sure to tell me what's the table's and chart's IDs so I know where to look.
Please correct me if I'm wrong here, but it looks like this is "datetime", not "time" format. Please note that you should have the same format in WP settings, wpDataTables settings and in the database to avoid any conflicts like this.
Could you also show me the structure of the columns in the MySQL table?
When it comes to charts, you can manipulate them if you're familiar with 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 Support help center). 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 certain level of programming skills and included support refers only to advice.
As for removing the prefix:
You can add the following CSS when you create the page:
Hello,
I'm using a Mysql table with the "time" data format, in table view the time shows correctly however the graph shows all data points as 12am
further when i use date a similar thing happens where the date is shown as 01/01/1970 on the graph but correctly in the table.
Hello william.
Thank you for your purchase.
Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.
Also, if at all possible, could you also provide the PHPMyAdmin (database) credentials, so I can see the table in the database as well?
Please make sure to tell me what's the table's and chart's IDs so I know where to look.
Best regards.
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 again william
Understood.
Please correct me if I'm wrong here, but it looks like this is "datetime", not "time" format. Please note that you should have the same format in WP settings, wpDataTables settings and in the database to avoid any conflicts like this.
Could you also show me the structure of the columns in the MySQL table?
Best regards.
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 again william.
When it comes to charts, you can manipulate them if you're familiar with wpDataCharts callbacks.
As for removing the prefix:
You can add the following CSS when you create the page:
Or, if you want to apply this to every table, you can simply add this to Custom CSS field in main wpDataTable settings:
Best regards.
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