> ## Documentation Index
> Fetch the complete documentation index at: https://docs.openlit.io/llms.txt
> Use this file to discover all available pages before exploring further.
# Bar Chart Widget
> Learn how to use the Bar Chart Widget in OpenLIT to compare grouped data using ClickHouse queries and dynamic filters.
The **Bar Chart Widget** in OpenLIT is great for comparing categorical or grouped data—like errors by type, usage by region, or revenue by plan. You can customize the chart direction, stack behavior, and bind dynamic filters directly into your ClickHouse queries.
## When to use
* Comparing usage across different platforms or regions
* Visualizing grouped data like plan types, error categories, or product segments
* Monitoring metrics over categories with filter support
## How to add a bar chart
Example:
```sql theme={null}
WITH
parseDateTimeBestEffort('{{filter.timeLimit.start}}') AS start_time,
parseDateTimeBestEffort('{{filter.timeLimit.end}}') AS end_time,
SELECT
SpanAttributes['gen_ai.request.model'] AS model,
CAST(COUNT(SpanAttributes['gen_ai.request.model']) AS INTEGER) AS model_count
FROM
otel_traces
WHERE
SpanAttributes['gen_ai.operation.name'] != 'vectordb'
AND notEmpty(SpanAttributes['gen_ai.request.model'])
AND Timestamp >= start_time
AND Timestamp <= end_time
GROUP BY
model
ORDER BY
model_count DESC
LIMIT 3
```
## Configuration Options
* **Color palette**
* **X/Y label & value paths**
Use dynamic bindings like `{{filter.timeLimit.start}}`, `{{filter.timeLimit.end}}` to make your chart respond to dashboard time filters.
## Best practices
* Sort bars by descending value for clearer insights
* Limit category count (e.g., top 10) to avoid clutter