Solved: Setting up an interactive dashboard - Page 2

gcor71 · 08-23-2024 10:14 AM

Forum Friends, your help please - I've reached the absolute limit of my knowledge, experience and ability to research solutions myself.

I have a table slice - myGroup (view shown below)

I want to allow users to select a 'Related SECTIONs' row (see the left side of the image) and have the 'Related WAITING_LISTs by _suggestedGroup' (see the right side) update to focus on just the selected Related SECTION. It can be in a different view format - this image is just to help explain.

I believe a two view Dashboard with interactive mode ON should achieve this - however, I've not been able to get anything like that to work.

My experience suggests it's probably easier than I imagine - but I can't figure it out. All help, suggestions and pointers gratefully received.

G

lynchk21

If I am not mistaken, you will need to do the following:

Create a new table to use for your filtering. If can just be one column and one row
Create an action to update the value in the new table to the SECTION (or reference column) that you are using to filter
Update the slice for the Related WAITING_LISTs by _suggestedGroup view to filter based on the value in the new table
Update the behavior of your inline view to run the action when the row is selected

I think this should work. Although I am not sure if the inline view being part of the parent detail view will have an impact. Let me know if you try it!

View solution in original post