Skip to content
Shield360 Shield360 Shield360

Bar Chart Widget

The Bar Chart Widget in Shield360 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

Section titled “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

Section titled “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

Section titled “Configuration Options”
  • Color palette
  • X/Y label & value paths

Best practices

Section titled “Best practices”
  • Sort bars by descending value for clearer insights
  • Limit category count (e.g., top 10) to avoid clutter