Is there a way to achieve both "and" and "or" in filter group

Q&A
, ,
1

I have reviewed this post: Adding filter conditions (group filters) with AND and OR operators - Amazon QuickSight, and this does not seem possible, but wanted to see if there is any way to implement this. Currently I have filters that ideally should work this way: (Filter A and Filter B and Filter C) OR (Filter D and Filter E and Filter F). (Filter A and Filter B and Filter C) should be one group of filters, and (Filter D and Filter E and Filter F) is another group. The data that satisfies either one group of these filters will be selected. Can this be done in Quicksight?

2

Hi @Bruton3

You could try implementing this using a mix of calculated fields and a filter

a. Each Filter (Filter A, B, C ) could be a calculated field checking your values from the dataset and return a boolean 1 or 0 value
b. Create a Final Calculated field where you can use the ifelse to filter based on your requirement, finally producing a 1 or 0 based on your AND and OR logic
c. Apply a Filter on the Final Calculated field to filter

If you share more details on what your filters are and provide dataset details we could probably suggest in a little more detail

1 Like
3

Hi @Bruton3,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Bruton3,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!