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:

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