Line Chart Widget

The Line Chart Widget in Shield360 helps you visualize changes in your metrics over time with sharp, precise lines. It’s ideal for tracking KPIs like API latency, CPU usage, conversion rate, or funnel performance.

When to use

Use a Line Chart when you want to:

Monitor trends over time with a high degree of accuracy
Display sharp, distinct movements in your data
Compare multiple metrics on the same time scale

How to add a line chart

Example:

WITH
  parseDateTimeBestEffort('{{filter.timeLimit.start}}') AS start_time,
  parseDateTimeBestEffort('{{filter.timeLimit.end}}') AS end_time,
  dateDiff('day', start_time, end_time) AS days_diff,
  dateDiff('year', start_time, end_time) AS years_diff,
  multiIf(
      years_diff >= 1, 'month',
      days_diff <= 1, 'hour',
      'day'
  ) AS date_granularity
  SELECT
    CAST(COUNT(*) AS INTEGER) AS total,
    formatDateTime(DATE_TRUNC(date_granularity, Timestamp), '%Y/%m/%d %R') AS request_time
  FROM otel_traces
  WHERE
  SpanAttributes['gen_ai.operation.name'] != 'vectordb'
  AND StatusCode IN ('STATUS_CODE_OK', 'STATUS_CODE_UNSET', 'Ok', 'Unset')
  AND Timestamp >= start_time AND Timestamp <= end_time
  GROUP BY request_time
  ORDER BY request_time

Customization options

**Custom line colors
X/Y label and value paths

Best practices

Use GROUP BY with consistent time buckets (e.g., minute, hour)
Order your results by time to ensure correct rendering