I want to have a dashboard view that will basically have two screens.
One is a choice, lets say to choose between View A, View B, View C etc; and the second is the view that is chosen in the first view. Views A, B C are made from different tables.
Is there a way to achieve this?
I thought of using slices but a slice is essentially a โsliceโ of the same table.
Solved! Go to Solution.
Please
Create a single row table called say โViewsSelectโ with two columns ID (key), ViewName (Enum type ,Text base ) Enum Options: Names of views that you wish to appear selectively in dashboard.
The table vill be multirow with column for useremail for multiple users- one row to retain selection of each user.
Create a detail view called say โViewSelectโ on above table with column โViewNameโ as Quickedit
Include โViewSelectโ view and ALL views that you wish to be selected through Enum in a dashboard view
For each of those views except โViewSelectโ view , the show_if will be
ANY(ViewsSelect[ViewName])= โView Nameโ
e.g. For a view called โOrdersโ the Show_if will be ANY(ViewsSelect[ViewName])= โOrdersโ
The expression will change for multi user environment. You will need to bring in user email in teh expression.
Like this?
Exactly this.
Please
Create a single row table called say โViewsSelectโ with two columns ID (key), ViewName (Enum type ,Text base ) Enum Options: Names of views that you wish to appear selectively in dashboard.
The table vill be multirow with column for useremail for multiple users- one row to retain selection of each user.
Create a detail view called say โViewSelectโ on above table with column โViewNameโ as Quickedit
Include โViewSelectโ view and ALL views that you wish to be selected through Enum in a dashboard view
For each of those views except โViewSelectโ view , the show_if will be
ANY(ViewsSelect[ViewName])= โView Nameโ
e.g. For a view called โOrdersโ the Show_if will be ANY(ViewsSelect[ViewName])= โOrdersโ
The expression will change for multi user environment. You will need to bring in user email in teh expression.
Got it.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |