Let me start by saying yes i know a custom query can solve this, but i am trying to solve this in Analyses.
Table 1 Visual returns a list of CaseNumbers based on some filters.
I want to take the CaseNumbers from Table1 and use that as an exclude filter in Table2. Can i achieve this in analyses?
Hi @debonisd,
Unfortunately QuickSight filter options are fairly limited when working on the analysis level. While you can use them to exclude from a visual, there’s no great way to limit the values returned based on another visual’s filtered results.
I’ll mark this as a feature request to promote visibility to the support team.
Hi @debonisd,
Following up here as it’s been awhile since last communication took place on this thread; while I’ve marked this as a feature request already, I wanted to double check if you had any additional questions or comments to add?
If we do not hear back within the next 3 business days, I’ll close out this topic.