Toggle

{% toggle
    id="show_legend"
    label="Show Legend"
/%}

{% toggle
    id="show_legend"
    label="Show Legend"
/%}

{% toggle
    id="active_only"
    label="Active Only"
/%}

{% table
    data="demo.daily_orders"
    where="{{active_only}} = false or total_sales > 1000"
/%}

{% toggle
    id="active_only"
    label="Active Only"
/%}

```sql filtered_orders
select * from demo.daily_orders
where {{active_only}} = false or total_sales > 1000
```

{% table data="filtered_orders" /%}

{% toggle id="active_filter" /%}

```sql active_users
select * from users
where is_active = {{active_filter}}
```