GridscriptDonate

Visualize Stage

The Visualize stage previews data from a context field as a table, a chart, or both. It reads rows from your pipeline context, applies an optional row range, and renders views without modifying the context.

What the stage does

  • View modes — Table, Chart, or Table + Chart.
  • Source field — Must be an array of rows (arrays or objects). Errors if missing or not an array; errors if the selected range is empty.
  • Row range — Start/End rows (inclusive) to scope the preview; rows outside the range are ignored.
  • Chart types — Line, Bar, Area, Scatter, Bubble (with size field), Pie, Donut.
  • Series — One or more Y series; each has its own chart type, label, and optional log scale (non-pie/donut).
  • X / Y mapping — Pick X field/column and one or more Y fields. Pie/Donut use angle and callout labels; Bubble adds a size field.
  • Axis names — Optional X/Y axis labels plus chart title and subtitle.
  • Output — Renders views (table/chart) in the stage; does not write data back to context.

Configure the Visualize stage

  1. Choose a Source field (context path of the data to preview).
  2. Pick a View: Table, Chart, or Table + Chart.
  3. Optionally set Start row and End row (inclusive indexes) to limit the preview.
  4. For charts:
    • Set X field (column index or property).
    • Add one or more Series:
      • Y field (value field for pie/donut).
      • Label/name (legend or slice label).
      • Chart type: Line, Bar, Area, Scatter, Bubble (optionally set Size field), Pie, or Donut (multiple donuts stack with concentric rings).
      • Log scale toggle (non-pie/donut).
    • Optional: X axis name, Y axis name, title, subtitle.
  5. Click Run Stage (or Run All) to render the table and/or chart. No context fields are modified.

Example: revenue by month

Source field: revenue

  • View: Table + Chart
  • Start/End row: 0 to 100
  • X field: Column 0 (Month)
  • Series 1: Column 1 (Revenue), Line, name "Revenue"
  • Series 2: Column 2 (Target), Line, name "Target"
  • Title: "Revenue vs Target"

The stage shows a table of the selected slice and a dual-line chart. Downstream stages remain unaffected because Visualize does not write to context.

Tips for effective visuals

  • Clean data first: Use Transform to normalize numbers/dates before charting.
  • Scope big tables: Limit Start/End rows to keep charts responsive.
  • Label clearly: Set axis names and series labels to make charts readable; use subtitles for context.
  • Pick the right chart: use Bubble for 3 variables, Pie/Donut for composition, Line/Area for trends, Bar for comparisons.