Looking to see if there are any fancy expressions to place a kind of ignore / don’t ignore empty constraints on a Dashboard that has a Detail view and a Table view.
I have created an Interactive Dashboard that Includes from left to right:
Table Deck view of records
Detail view for a selected record with specific columns showing
Detail view for the same record just showing a Ref_Row column with it’s Inline Table
Another Detail view for the same record just showing another Ref_Row column with it’s Inline Table
This works nicely but I don’t like the way the inline tables look since they have different sizes due to different number of related records. So I tried using Table views for those related tables and with Interactive mode it works but you get all the records of those two Table views when no row is selected on the left most Table view. So I have an empty Detail view and two Table views showing all possible records. Just looks odd.
So I was wondering if there is a way to, take away Interactive mode, and instead place some kind of LINKTOFILTEREDVIEW expression as an action for selecting a row on the left most Table view that would filter the Detail view and the two Table views OR maybe ask for a Feature that would allow you to decide if a view inside an Interactive Dashboard should bring all records when loaded (as it does now) or just show no records until a selection has been made on one of the other Views in the Dashboard.
Create a Selection table to hold the key of the first table you have selected
You should make the table ‘user aware’
Create an action on the first table to update the Selection table with the key value
You might want to make the action so that when you select the row already in the Selection table, you reset the value to “”, otherwise the newly selected row’s key
Set the action on the Row Selected event
Create slices for your related tables and apply a filter based on the Selection table value
This worked almost to my total satisfaction, sooo close. The tables and views all get populated correctly and it all works like I wanted it to. But there’s one little UX thing that I guess can’t be dealt with: The selected row on the First Table that has the action to filter the rest of the views in the Dashboard does not stay visually selected. Here’s an image of how it stays selected using regular Interactive Dashboard:
