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 #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