We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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