Okay
  Public Ticket #3537692
dynamic relational charts
Closed

Comments

  • Johan van Bussel started the conversation

    i want to build a dashboard with charts that behave dynamic: if i select a bar in 1 chart, another chart adapts to that selection. is that possible in wpdatatables? 

  •  1,708
    Miloš replied



    Hi Johan,

    Sorry to disappoint you, but it is not possible to create one Filter which can affect multiple Charts at the same time;

    Same goes for Tables - each Table will have Column filters - and if we change any filter on Table 1 , it can not affect Table 2, and so on.

    The only current way to have one filter affect multiple Tables/ and thus Charts;

    is to use our URL pre-filtering feature;

    For example, if you set up several Tables on same Page, and if they have the same Column Name - and you pass some filter parameter in this Page URL;   then all Tables on that Page which have same column Name will be affected;

    but it is not possible to achieve the same effect on an actual Column filter in the Tables.

    -

    You can make a development suggestion for this.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.




    2.   Just an additional advice ( sorry if you already know this workaround) about using filters on Charts.

    The Charts can only be filtered from their source Tables;

    By default, the charts will not follow any filtering from their source table if you just put the chart "on its own" on the page.

    But If you place the source table together with its chart on the same page,

    and activate " Follow Table filtering"  on the chart Wizard settings,  it is going to follow any filtering/sorting you do on the table.

    -

    Now, depending if you wish to hide the table and have a filtering for Charts, we can have two workarounds available.

    1. If you wish to hide the entire table along with table filters;

    you can add this CSS to the table's back-end settings/Customize/Custom CSS.

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

    This will completely hide the table from the page, but you can still pass the table shortcode with the chart, and you will get the "follow table filtering" effect on this chart.

    2. Or if you wish just to hide the table while leaving the filters with the chart,

    we would first need to disable the following in the table settings:

    "Show X entries" drop-down; "Info Block" from Display tab:

    5739555450.png

    Then, "Enable main search block"  and "show filters in a form above the table" from the Sorting and Filtering tab:

    7822122957.png

    Then, you can add this CSS in the table settings/Customize/Custom CSS:

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

    That will just leave the chart visible with the filters on the page,

    if you pass both table and chart shortcodes.



    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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