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 #2484189
Charts
Closed

Comments

  • Andrew started the conversation
    July 25, 2020 at 7:46am

    I can't find a way to chart data coming from several tables.

    I have front end, user edits own data tables. 

    I've split my data across several tables to keep it organised and minimise the database calls.  And I can chart each one individually, 

    But charts only allows data to be gathered from a single table. So I cant chart data sourced from multiple tables.  So I thought I would collect the relevant data into one table and chart that.  But I cant seem to achieve it.

    There are just 3 integer fields in each table, and I just want to chart the average of each column - so just 3 numbers from 7 tables.  

    I got the "average" shortcodes from each table and column, but parsing the shortcodes into another table creates a string, not an integer, so I cant chart that table either.

    Is there any way I can collate the numbers I need into one table, as integers, so I can chart it?  

    AJ  

  •  2,576
    Aleksandar replied
    July 27, 2020 at 1:25pm

    Hello Andrew

    I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

    You could only create a new SQL Query based table, that would pull the data from all other tables into one, and then create a new chart from that data table.

    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