Ignore or don't ignore empty constraints for Interactive Dashboard

[Hamlet]

Hello everyone,

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.

Thanks in advance!

[TeeSee1 · Accepted solution]

One way I implemented in this situation.

• Set the DB to non interactive mode
• 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

Hope this solves your requirement.

[Hamlet]

This sounds pretty good. I'll give it a try and report back.

[Hamlet]

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:

But using your method, everything works great but the row won't get highlighted like that.

Now I can't decide what I can tolerate more, the Detail Views with the Inline tables of different sizes or the Rows selected not getting highlighted...

Anyhow, thanks so much for this tip, definitely gonna keep this one around.

[TeeSee1]

you can try using Format rules to highlight a selected row. 

[Hamlet]

Yes. I'm currently playing around with format rules.