Filtering out a table based on the stacked bar graph selection

[Nivis18]

Hi,

I am trying to create a view in which we have two tables- One is the aggregated one and other is the raw data. I want two visuals in it, one is the stacked bar graph from the aggregated table and another is a table of raw data.

I want whenever the user click on any stack of the stack bar chart it should be able to filter out the data in the table based on that selection.

Any idea how to do that?

[Coriel-11 · Accepted solution]

You need to connect the two table together in Model view (third icon down on left, shows you the two tables next to each other. Then drag one field where the values are found in both tables from one to the other - they should now appear connected).

When you create the visualisation in Report view this should then work automatically.
If it doesn't click on the bar chart, select "Format/Edit interactions" and then on your raw table click on the icon that's a chart with a small filter in front of it.

Matt

[JorgePinho]

Can you connect the tables in the model?