# COUNTBY

COUNTBY( `column`, `partition column`) 

Counts the number of values within a `column` when grouped by unique values within a `partition column`.

{% hint style="info" %}
COUNTBY() is a [**window function**](https://docs.cascade.io/cascade/functions-and-expressions/building-expressions/guide-to-window-functions)**,** which performs COUNT() except partitioned by the unique values of a separate column.
{% endhint %}

### Arguments

| Input              | Description                      |
| ------------------ | -------------------------------- |
| `column`           | Column to count                  |
| `partition column` | Column containing unique values. |

### Output

Outputs a count of values when grouped by `partition column`.

### Example

In this example, we want to count the number of non-null cells in `{Adult Population}`, partitioned by `{Region}`. 

{% embed url="<https://datawrapper.dwcdn.net/ZNaf2/1/>" %}