Bar chart

A bar chart compares numeric values across categories. Use it for products, statuses, regions, or plans — anything where the X-axis is a name, not a continuous time series.

Category

categoryField is the column of labels along the axis (or along the left side when the chart is horizontal).

Values

valueFields are the numeric columns to draw as bars. One value field gives a simple bar per category. Several value fields draw a group of bars per category (or a stack, if stacking is on).

Chart options

  • Stacked bars — place multiple value fields on top of each other instead of side by side. For a dedicated stacked visualization with wide or long data, use Stacked bar chart.
  • Horizontal — useful when category names are long.

Example query

SELECT
  plan,
  COUNT(*) AS customers,
  SUM(mrr) AS mrr
FROM subscriptions
WHERE account_id = :customer_id
GROUP BY plan

Map Category to plan and Values to customers and/or mrr.