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 #2880044
Help with stacked line graph
Closed

Comments

  • John started the conversation

    I have integrated with Formidable Forms and now have a wpDataTables table. I am trying to create a stacked line graph from one record in the data table. The data table has multiple entries but I want a graph from only one of the entries. I have 12 revenue fields and 12 cost fields in each record in the table and want to show a stacked line graph similar to the one in the attachment. Can I do this with wpDataTables?

  • [deleted] replied

    Hi John

    Thank you for reaching out to us.

    In this case I would suggest using Follow table filtering option and prefilter your table to display only the desired value. You can filter the table with placeholders and then hide the table from displaying on the page.

    You can add a filter through the shortcode if you assign one of our placeholders to column settings/filters/predefined filtering value.

    8052151734.png

    If you add %VAR1% as a predefined filtering value to ColumnA, for example, it will load all the data (because the placeholder is not defined in the Placeholders tab above the table). Then, when you add the shortcode like:

    [wpdatatable id=1 var1=150] it will filter the table per columnA with the value of "150".

    If you need to hide the filters, a simple css like this would be enough:

    .wpdt-c .wpDataTables.wpDataTablesWrapper {
    display: none !important;
    }
    

    You can hide the table, leaving the filters above the chart like this:

    <style>
    .wpdt-c .wpDataTablesWrapper table {
    display: none !important;
    }
    </style>
    [wpdatatable id=1]
    [wpdatachart id=1]
    

    And that's it. This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.