Action on graph to filter table data - Toggle

[Marvin]

I'm trying to make a graph interactive so that the table below shows the values for the column I clicked in the graph.

In my attached example "Graph-Table" I want the following to happen:

1. Click on the bar 3/2019
2. Only the 2019 group shows in the table below. All the rest of the years are hidden
3. Click on the bar 1/2018
4. Only the 2018 group shows in the table below. All the rest of the years are hidden

In the attached report, you see I tried adding some interaction, but I don't know how to get it to toggle/filter the data.

[Marvin]

In addition or as an alternative I'd like to be able to use the interactive tool to filter an embedded subreport, but I can't find a way to do that either. Same type of situation as above, but rather than a local table, use a subreport. I don't want the user to need to go out of the current report to see the drilled down info.

[Neli]

Hi Marvin, 

You can use a NavigateToReport Action and update the report once the user has clicked on a group. To filter the data, you need a report parameter. Its value will be passed to the filter.

I attached the updated report. Please, test it and let me know how it goes.

[Marvin]

Thank you! That's exactly what I ended up doing, but I don't like the idea of reopening the report every time. I want to navigate and stay within the same report. 

Why?

1. Because it takes time to render the report again, and I don't like the delay.

2. I want it to be smooth action, where you don't have the user waiting for the report to respond.

If I could filter the table in the embedded subreport, and not go outside of the current page, it would help a lot. I haven't found a way to send an interactive parameter to an embedded subreport.

Thanks again for answering and sending the sample. Any other ideas out there?

 

[Neli]

Hi Marvin,

Thank you for your update. In general, once you change the value of the parameter, then the whole report will be rerendered. This behavior is by design. The same is applied with most of the actions. I am afraid that there is no workaround that I can suggest.