I have a need to offer user an array of values in a filter, such as features on device. I have a set of filters on the main dataset that leverages the “show relevant values only” feature that allows me to tie filters together to limit the options. However the last filter had to be created from different dataset as data is a array and needs the option of contains in the custom filter. Do we have an option to limit options in custom filter based on selection of previous filters as “show relevant values only” normally provides? It appears to not be enabled if you have a custom filter to get the contains option?
Hi @Sanders77,
Currently, there is not a feature available in Quick Sight that allows this type of behavior between datasets..you would have to perform a join to fields from separate datasets work together.
This is standard behavior for any type of action that involves utilizing 2 datasets.
I will mark this as a feature request to promote visibility to the support team.
Thank you!
Thank you Brett,
I don’t believe join will work for this scenario as data that needs to be in nested filter is essentially an array. For example limit features by manufacture selected from previous filter. This works fine for single elements however if expand SQL in datasource with string_to_table it duplicates the rows in pivot table.
Thank you for bring visibility too this will look to see if can be prioritized.
1 Like