> ## Documentation Index
> Fetch the complete documentation index at: https://docs.evidence.studio/llms.txt
> Use this file to discover all available pages before exploring further.

# Repeat

> Repeats the children of this component once for each distinct value of a column

```liquid theme={null}
{% repeat 
	id="category_repeat" 
	data="demo.daily_orders" 
	column="category" 
%}
   {% line_chart
        data="demo.daily_orders"
        x="date"
        date_grain="month"
        y="sum(total_sales)"
        filters=["category_repeat"]
   /%}
{% /repeat %}
```

## Examples

### Basic Usage

```liquid theme={null}
{% repeat 
	id="category_repeat" 
	data="demo.daily_orders" 
	column="category" 
%}
   {% line_chart
        data="demo.daily_orders"
        x="date"
        date_grain="month"
        y="sum(total_sales)"
        filters=["category_repeat"]
   /%}
{% /repeat %}
```

### With WHERE Clause

```liquid theme={null}
{% repeat 
	id="top_categories" 
	data="demo.daily_orders" 
	column="category"
	where="total_sales > 1000"
%}
   ### {{top_categories}}
   {% line_chart
        data="demo.daily_orders"
        x="date"
        y="sum(total_sales)"
        filters=["top_categories"]
   /%}
{% /repeat %}
```

## Attributes

<ResponseField name="id" type="string" required>
  The id of this repeat component to be used in the `filters` prop of its children
</ResponseField>

<ResponseField name="data" type="string" required>
  The name of the table to query
</ResponseField>

<ResponseField name="column" type="string" required>
  The name of the column within the `data` table to get distinct values
</ResponseField>

<ResponseField name="where" type="string">
  SQL WHERE clause to filter which values to repeat over
</ResponseField>

<ResponseField name="filters" type="array">
  Array of filter IDs to apply when querying for distinct values
</ResponseField>