I am sure this is a fairly common use case, specially for desktop apps.
On a table view, I have list of customers. A user selects one of the customer on this table.
Based on the selected row, I want to to display a Dashboard view that has various views based just on that selected customer. In other words, this dashboad view is based on filtered/slice base on the selected row of the last view.
I have read through documentation and tried various tips listed here but none seems to work on dashboard views. For instance LINKTOFILTEREDVIEW() is not supported on Dashboard. I also tried an action where based on the selected row, it creates a new row in another table (filter table) which I use to slice the dashboard view. This seems highly inefficient way and takes 8-12 seconds for Dashboard view to update. There has to be a better way, is there?
The reason I want users to navigate to another dashboard view, instead of showing the info on the same view is that there is a lot of content to show - it is better to have a dedicated dashboard view for selected customer instead of using interactive dashboard where user selects customer on left side of the screen and details about selected customer are listed on the right side of the screen.