we are about to develop a webbased product for calculation of KPI's (Key performance indicators) for medium to large size companies.
Users shall login, provide monthly key data (such as revenue, employees, ...) and they want to receive monthly reports with charts upons this data. A poweruser/admin shall insert new formulas, that are then available for all the users.
My questions here are:
- Can data be extracted from SQL and be inserted into the wpDataTables? Background: We want a custom input form for the data.
- Can data be extracted from the wpDataTables so that they can be visualised in custom charts? (Background: We need custom charts with trendlines, target lines, some indicators yellow/orange/green), which I could not see in your chart library. So it would be mandatory for us, that the calculated data (the formula columns) can be extracted and shown elsewhere.
In short: We want to use the equation editor and the calculation feature from your plugin but insert the data from another source and show the calculated data elsewhere.
For data fetched from SQL our plugin has an option to create a table based on MySQL query. You can find more information about it in our - Documentation
For chart part there is no option to just pass the data to custom chart engine. It require developing custom solution which will fetch data, include files and create custom chart object with all parameters required. If the data are stored in MySQL maybe it would be easier to do this without wpDataTables by creating plugin which will do chart part separately
Hi,
we are about to develop a webbased product for calculation of KPI's (Key performance indicators) for medium to large size companies.
Users shall login, provide monthly key data (such as revenue, employees, ...) and they want to receive monthly reports with charts upons this data. A poweruser/admin shall insert new formulas, that are then available for all the users.
My questions here are:
- Can data be extracted from SQL and be inserted into the wpDataTables? Background: We want a custom input form for the data.
- Can data be extracted from the wpDataTables so that they can be visualised in custom charts? (Background: We need custom charts with trendlines, target lines, some indicators yellow/orange/green), which I could not see in your chart library. So it would be mandatory for us, that the calculated data (the formula columns) can be extracted and shown elsewhere.
In short: We want to use the equation editor and the calculation feature from your plugin but insert the data from another source and show the calculated data elsewhere.
Bye,
Wolfgang
Hi Wolfgang,
Thank you for your inquire.
For data fetched from SQL our plugin has an option to create a table based on MySQL query. You can find more information about it in our - Documentation
For chart part there is no option to just pass the data to custom chart engine. It require developing custom solution which will fetch data, include files and create custom chart object with all parameters required. If the data are stored in MySQL maybe it would be easier to do this without wpDataTables by creating plugin which will do chart part separately