As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1591461
KPI WebApp
Closed

Comments

  • Wolfgang started the conversation

    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

  • [deleted] replied

    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