Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Interaction between Stacked bar chart

Hello All,

 

Need your inputs.

 

I have a report which has 4 stacked bar charts. I want to make interaction like - if select a bar in one chart then it should lock there and act as a filter on another graphs and then if I select other graph (the bar in first chart still locked and not deselected) other bars should show the applicable data.

 

For example-

 

 

If I select a bar for 'Monday' in 'Crime by day' graph then other 3 should display the data for monday and then by still holding the Monday on I need to click on 'Feb' bar in 'Crime By month' graph and then remaining 2 top bars should display data for 'Monday' and 'Feb'.

 

Currenlty if I select the 'Feb' then 'Monday' gets de-selected.

 

Anyone has any idea about how to achieve this type of functionality? Please advise.

 

Thanks!

Show and Tell

6 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    unfortunately this kind of "hierarchical" or "cascading" filtering is not supported, I guess the concept of cross-filtering makes this currently very difficult.

     

    For this reason I use a matrix visual, where I can achieve something similar, because it's also possible to use a value as filter.

     

    Maybe this gives you an idea.

     

    Regards

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Tom,

       

      Thanks for quick response but I didn't understand how to get something closer with matrix visual. Could you please shed some light on this in details?

       

      Thanks

      Harshad

      • TomMartens's avatar
        TomMartens
        Super User
        8 years ago

        Hey,

         

        maybe this gives you an idea. The Matrix Visul has Month and Customer nested on rows and items on columns

         

        The first Screenshot shows all the values for the year 2015

         

        The next visual shows all the values of the year 2015 for the item 5, I just selected the column header I5

         

         

        And finally I selected the value 20 for April (Row Header) in the column I5

         

        Of course this is not exactly what you are looking for, but I got used to use the Matrix Visual to combine Filter in a lot of my reports.

         

        Maybe this gives you an idea.

         

        Regards

        Tom