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.

count

The count function calculates the number of values in a dimension or measure, grouped by the chosen dimension or dimensions. For example, count(product type) returns the total number of product types grouped by the (optional) chosen dimension, including any duplicates. The count(sales) function returns the total number of sales completed grouped by the (optional) chosen dimension, for example salesperson.

Syntax

count(dimension or measure)

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.

On this page: