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