> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.nvidia.com/sdgm/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.nvidia.com/sdgm/_mcp/server.

# COUNT

#### `COUNT(<table>.<column>, <start>, <end>, <unit>)`

## Description

Calculates the count of the non-N/A values in the specified `<table>.<column>` column starting from `<start>` days to `<end>` days. When used in the target field, the time period should be positive (in the future). When used in a temporal filter field, the time period should be negative (in the past).

This operator can be applied to columns of any type.

### Example 1

```Text PQL
COUNT(LOAN.AMOUNT, 0, 30)
```

### Example 2

To count all the rows, regardless of the N/A values, use `*` instead of column name, e.g.:

```
COUNT(LOAN.*, 0, 30)
```

### Training Considerations

* Kumo runs your pQuery over many historic slices of data and across all entities that meet your filter criteria to generate training examples.
* If for a given entity and historic data slice there are no fact rows to aggregate over, the training example label is set to the value 0.
* For all aggregations, the start time is **excluded** from the calculation and the end time is **included** in the calculation.
* The units for the start and end times is `days` by default but can be specified as `months` or `hours`.