CountIfs with OR/AND condition

Question & Answer
1

I’m trying to use a calculated field to get the count of companies between 2 and 5. The formula works if I pick either number but not if I use an AND or OR .Here’s one of the formulas I’ve tried:

countIf({Account UUID},{Active User Seat Count} <= 5) AND countIf({Account UUID},{Active User Seat Count} >= 2)

2

Hello @Tj39,

Welcome to QuickSight Community! We are glad to have you here!

About your question, the syntax for the AND and countif will be something like this.

countIf({Account UUID}, {Active User Seat Count} <= 5 AND {Active User Seat Count} >= 2)

You can always find the functions and operators reference with some examples on the QuickSight documentation

Hope this helps!

Kind regards,
Andres

1 Like
3

This worked. Thank you Kindly, Andres!

1 Like