Currently it is only possible to plot multi-line charts using the data organized in COLUMNS for each dataset.
Other applications like R and HighChart, Chart.JS and Googlecharts i am sure allow one to group data by labels contained in rows. Ie. For instance have a Stock Name per row of data and group the line plots by a Stock_Name column.
Currently in wpdatatables this is only possible through pivoting the table by Stock Name and dropping all other relevant information in the table.
This is very very inconvenient.
You need to program this into the wpdatatables plugin otherwise it is NOT fair to claim that you can easily plot Time Series Data whereas you CANNOT easily do so!
You are correct - using the plugin's built in features it is only possible to group the line chart using columns.
Please take a look at our documentation (HighCharts line chart). There you can see the "Car Depriciacion" chart.
The first column is being used to generate the X axis, and all other columns provide data where Y axis will cross with the X value. So to create the chart like seen in the provided example, it should look like this:
You mentioned the "Time Series Data" chart. I can't seem to recall where we have advertised this option is available with wpDataTables, so can you please point me to the documentation you found about this?
yes i see but this is a very limited way to plot multiple plots. In fact most graphing packages like R and I am sure chart.js as well allow you to group by data in rows. Like having the car type in your example not in columns but in ONE column called Car Type.
I think you can fix this in your Plugin since it means you cannot plot Time Series properly and I am considering other plugins that have this functionality and return this plugin as it is of limited use for my purpose.
Time Series Data i have seen it written in the context of your Plugin for sure.
You write on your website homepage that this plugin is the solution to the Financial Industry.
No one stores stock time series of shares with stocks in columns !!
That’s because the number of rows is limited to 4098 in MySQL! And there are 10,000plus stocks World wide.
It also doesn’t make sense to do so. Because a stock has more than one parameter that keeps changing like Open, High, Low, Close, Volume etc. Etc. That’s why in each row you have normally the stock code and all the other variables in columns per day recorded. It would be stupid to have one table for each and every variable!
So I suggest you look up how to modify this with regards to the Chart.js Plugin and HighCharts etc as I am 100% certain that it is possible already to do so within chart.js. You only need to pass through this option to the Plugin!
However, changing this would require changing the logic of the plugin. Also, you would have to set the highcharts for showing a great amount of data, which unfortunately is not implemented in the plugin. For showing a large number of data in charts, you would have to include special add-ons like boost.js module. Here's an example of how it might work:
I forwarded this to one of our developers for testing, and he'll get to it as soon as possible.
We'll get back to you as soon as we're done with testing the tables and charts for millions of entries. I can't promise any timeframe, but we'll try to do it as fast as possible.
I think your Plugin is one of the most powerful there are yet this simple feature is quite standard in most charting packages (R, Matlab, Plotly, etc) so you should really get this included since it means one can generalize the applications even more!
The fact you have a wordpress interface between MySQL and charting libraries that is able to do this is then a lot more worth than currently!
If you don't have any sensitive data, would you be able to send us your database (the one with above million entries), so we can test it thoroughly on our end?
Currently it is only possible to plot multi-line charts using the data organized in COLUMNS for each dataset.
Other applications like R and HighChart, Chart.JS and Googlecharts i am sure allow one to group data by labels contained in rows. Ie. For instance have a Stock Name per row of data and group the line plots by a Stock_Name column.
Currently in wpdatatables this is only possible through pivoting the table by Stock Name and dropping all other relevant information in the table.
This is very very inconvenient.
You need to program this into the wpdatatables plugin otherwise it is NOT fair to claim that you can easily plot Time Series Data whereas you CANNOT easily do so!
Hi again A3igner.
You are correct - using the plugin's built in features it is only possible to group the line chart using columns.
Please take a look at our documentation (HighCharts line chart). There you can see the "Car Depriciacion" chart.
The first column is being used to generate the X axis, and all other columns provide data where Y axis will cross with the X value. So to create the chart like seen in the provided example, it should look like this:
You mentioned the "Time Series Data" chart. I can't seem to recall where we have advertised this option is available with wpDataTables, so can you please point me to the documentation you found about this?
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
yes i see but this is a very limited way to plot multiple plots. In fact most graphing packages like R and I am sure chart.js as well allow you to group by data in rows. Like having the car type in your example not in columns but in ONE column called Car Type.
I think you can fix this in your Plugin since it means you cannot plot Time Series properly and I am considering other plugins that have this functionality and return this plugin as it is of limited use for my purpose.
Time Series Data i have seen it written in the context of your Plugin for sure.
You write on your website homepage that this plugin is the solution to the Financial Industry.
No one stores stock time series of shares with stocks in columns !!
That’s because the number of rows is limited to 4098 in MySQL! And there are 10,000plus stocks World wide.
It also doesn’t make sense to do so. Because a stock has more than one parameter that keeps changing like Open, High, Low, Close, Volume etc. Etc. That’s why in each row you have normally the stock code and all the other variables in columns per day recorded. It would be stupid to have one table for each and every variable!
So I suggest you look up how to modify this with regards to the Chart.js Plugin and HighCharts etc as I am 100% certain that it is possible already to do so within chart.js. You only need to pass through this option to the Plugin!
Limit is 4098 columns ...
I see, A3igner.
I completely understand what you mean.
However, changing this would require changing the logic of the plugin. Also, you would have to set the highcharts for showing a great amount of data, which unfortunately is not implemented in the plugin. For showing a large number of data in charts, you would have to include special add-ons like boost.js module. Here's an example of how it might work:
https://jsfiddle.net/gh/get/jquery/1.7.2/highslide-software/highcharts.com/tree/master/samples/highcharts/boost/line/
I forwarded this to one of our developers for testing, and he'll get to it as soon as possible.
We'll get back to you as soon as we're done with testing the tables and charts for millions of entries. I can't promise any timeframe, but we'll try to do it as fast as possible.
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
i understand. That would be awesome yes!
I think your Plugin is one of the most powerful there are yet this simple feature is quite standard in most charting packages (R, Matlab, Plotly, etc) so you should really get this included since it means one can generalize the applications even more!
The fact you have a wordpress interface between MySQL and charting libraries that is able to do this is then a lot more worth than currently!
Hello again A3igner.
If you don't have any sensitive data, would you be able to send us your database (the one with above million entries), so we can test it thoroughly on our end?
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