WPDataCharts will not show the Scatter Plot graph correctly using Highcharts.
The data are sorted correctly on the x-axis, but the Y-axis is in no particular order. The tooltip is also wrong and I found out that the value shown in X is equal to the row+1 in the database table?
Can you please explain me which data source you use for making table that you use for making this chart? Is it possible to send me that data source os I can take a look and investigate in our local environment?
Yes it is showing that results because you are using only number columns for this chart. If you don't insert string column in chart wizard wpdatachart engine will take first column that you insert and make from her xAxis in chart. Categories will be populated in order like in table and values will start from 0. I suppose that you use Invert option in chart wizard where axis are inverted. I will forward this to my team to investigate.
Yes google charts and highcharts are different engines and have different methods for creating the charts. This is a issue with Scatter Plot graph when you use only number columns(integers or floats). My team will try to fix this for next update, but there are some priority task that have to be done so will be fix for one of next versions. My suggestion for now is to use Google engine for this chart. Thank you very much for reporting this and sorry for any inconvenience.
WPDataCharts will not show the Scatter Plot graph correctly using Highcharts.
The data are sorted correctly on the x-axis, but the Y-axis is in no particular order. The tooltip is also wrong and I found out that the value shown in X is equal to the row+1 in the database table?
On highcharts website they have an example on how it should sort both axis at the same time - here is the link https://www.highcharts.com/demo/scatter
Hi Jacob,
Thank you for your purchase.
Can you please explain me which data source you use for making table that you use for making this chart? Is it possible to send me that data source os I can take a look and investigate in our local environment?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Jacob,
Yes it is showing that results because you are using only number columns for this chart. If you don't insert string column in chart wizard wpdatachart engine will take first column that you insert and make from her xAxis in chart. Categories will be populated in order like in table and values will start from 0. I suppose that you use Invert option in chart wizard where axis are inverted. I will forward this to my team to investigate.
Best regards
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
Thanks for following up on this :-)
This doesn't sound optimal so I look forward to feedback from development team.
An interesting observation is that when I use google charts instead of highcharts, it works fine with the same datasource and number columns (check http://dev-fleet-manager.pantheonsite.io/datachart-example-2/)
All the best,
Jacob
Hi Jacob,
Yes google charts and highcharts are different engines and have different methods for creating the charts. This is a issue with Scatter Plot graph when you use only number columns(integers or floats). My team will try to fix this for next update, but there are some priority task that have to be done so will be fix for one of next versions. My suggestion for now is to use Google engine for this chart. Thank you very much for reporting this and sorry for any inconvenience.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables