I have an interactive dashboard with A:List of rows B:detail for said row C:list of related rows that reference view A. I need the view C to be blank is nothing is selected in A. Currently when nothing is selected in view A, every row is shown in view C.
Solved! Go to Solution.
I donโt think itโs possible with the dashboardโs interactive mode. I suspect youโd have to use a slice and actions in view A to manage the slice.
I donโt think itโs possible with the dashboardโs interactive mode. I suspect youโd have to use a slice and actions in view A to manage the slice.
Hi @Austin_Lambeth please share the solution, when you found one. Iโm also interested in this one
Oh I already have that solution elsewhere but that situation had more benefits to using it than this one so I wanted to avoid using it.
MAX(
SELECT(
CurrentInvoice[CurrentTimeStamp],
[UserEmail]=Useremail()
)
)
Then you use this slice to filter a slice that is displayed in your dashboard.
This is even more useful if you want to make dashboards that navigate to dashboards. I use it in a main navigation dashboard for invoices and take my users to a filtered dashboard based on their selection. So technically my solution does not do this in its current form but 99% sure it will translate just fine.
User | Count |
---|---|
62 | |
25 | |
14 | |
11 | |
6 |