Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

countIf

Based on a conditional statement, the countIf function calculates the number of values in a dimension or measure, grouped by the chosen dimension or dimensions. For example, countIf(ProdRev,CalendarDay >= ${BasePeriodStartDate} AND CalendarDay <= ${BasePeriodEndDate} AND SourcingType <> 'Indirect') returns the total number of product types grouped by the (optional) chosen dimension, including any duplicates. The countIf(sales) function returns the total number of sales completed grouped by the (optional) chosen dimension, for example salesperson, provided the condition evaluates to true.

Syntax

countIf(dimension or measure, condition)

Arguments

dimension or measure

The argument must be a measure or a dimension. Null values are omitted from the results. Literal values don't work. The argument must be a field.

condition

One or more conditions in a single statement.

On this page: