Filter AND/OR

Question & Answer
, ,
1

Hello everyone,

I would like to know, if it’s possibile to use the AND operator in filter groups, while using the OR operator to divide groups.

I will attach a picture for easier understanding.

Thanks

Cattura
Cattura370×400 16.6 KB

1 Like
2

Hello Luca,

First of all Welcome to teh QuickSight Community !

Text from official document-
In analyses, when you add multiple filters to a visual, Amazon QuickSight uses the AND operator to combine them. You can also add filter conditions to a single filter with the OR operator. This is called a compound filter, or filter group.

To add multiple filters using the OR operator, create a filter group. Filter grouping is available for all types of filters in analyses.

Please see this for better understanding -Adding filter conditions (group filters) with AND and OR operators - Amazon QuickSight

hope this helps in your requirement.

Thank you.
Cheers,
Deep

3

Hey,

thank you for the reply and the welcome!

Im having some issues on how to actually add AND/OR operators, it doesn’t seem to be there. Are there any screenshots/videos on how to do it?

Thank you

LC

1 Like
4

Hello Luca,

I don’t think you can explicit add AND /OR… If you apply filters individually it will be with AND and if you apply filter condition within the applied filter then it will be OR.
Therefore, you may probably need to apply the filters accordingly.

hope this helps.

Cheers,
Deep