I am trying to show data from table in remote MySQL database. Data in the table is appending every minute and I want to show only the last hour in my graph. I am using descending order by time with limit of 60 and it works perfectly fine with google charts. Chart.js is also showing the right data but x-axis is in reverse order (you can see it in attached photo). Is there any way to fix this issue because I would really like to use this chart engine, it looks nicer for what I need.
If it's easier for you, we can continue in Serbian (Croatian, Bosnian, which ever language you speak).
If I'm not mistaken, the chart engine uses its own sorting logic, and that can't be changed from within the plugin. The free library we're using isn't offering those options.
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.
I am trying to show data from table in remote MySQL database. Data in the table is appending every minute and I want to show only the last hour in my graph. I am using descending order by time with limit of 60 and it works perfectly fine with google charts. Chart.js is also showing the right data but x-axis is in reverse order (you can see it in attached photo). Is there any way to fix this issue because I would really like to use this chart engine, it looks nicer for what I need.
Hello Andrea
Thank you for your purchase.
If it's easier for you, we can continue in Serbian (Croatian, Bosnian, which ever language you speak).
If I'm not mistaken, the chart engine uses its own sorting logic, and that can't be changed from within the plugin. The free library we're using isn't offering those options.
You can check in our documentation about 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
Hvala na odgovoru! Problem je riješen
Nema na čemu, Andrea
Ako imate još neka pitanja ili probleme, slobodno nas kontaktirajte i rado ćemo Vam pomoći
Srdačan pozdrav!
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