Hi, the end goal is to turn off a UX View if there are no related records for the selected row of an interactive dashboard. The two ways I see this being done is:
- Somehow getting the selected row from the dashboard and then I can run a COUNT with FILTER function.
- Somehow being able to call COUNT on the filtered information itself. (Interactive dashboard causes filters on related tables that are shown).
Any help would be greatly appreciated.
PS. The reason for this is that I have different information spread over tabs of a dashboard and want to remove any tab that is empty.