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:
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
