We would like to hide dashboard graphs/tables/… until a user has filtered down the report to maximum 3 different unique IDs. Essentially, we would like to force the user to filter on a particular ID in the filter on top first, before trying anything further. We would also be happy to filter all visuals to display zero results until the user has filtered for a particular ID (max 3 IDs).
I have already explored:
calculated fields: distinct_count(ID) => filter on e.g. a table with maximum value 3, but this filters on a row-level still
Parameters: but I do not succeed in making this dynamic based on a count of distinct values
Hi,
A little tick if work for you.
You can set your filters default value where no data exists.
All the visual will remain blank until your choose the filter and change them.
Thanks Naveed, that is a helpful tip.
We have 2 filters that can act on row level (ID filter & title filter). If I set the default value of the “ID contains” filter to be empty, then the inexperienced users of the embedded dashboard are likely to be confused when they enter an ad title but it does not return any results.
It would be ideal if I could use a calculated variable that counts all the unique records (as currently filtered or seen in dashboard) + potentially use this as a parameter input, and if it is less than 3, filter out or hide all the dashboard visualizations. That is not possible in Quicksight?
I am not sure if calc field can be the solution for it, as we can’t customize the filter behavior on the multiple filters the only solution I can think of is to use dataset parameter with custom SQL where you can customize the filtering behavior directly on the SQL to the data source.
there is Learning Series for the feature just delivered lately.