Customer Dashboard Help

Scatter plot

A scatter plot puts one marker per query row. You need two numeric columns: X and Y. Optional columns can color or size the markers (a bubble chart).

Do not pre-aggregate unless you want one marker per group. Raw or lightly grouped rows work best.

X-axis field

xField — numeric (or date-like) column for the horizontal position.

Y-axis field

yField — numeric column for the vertical position.

Color by

colorField is optional. It adds a third dimension:

  • Categorical color mode — one color per distinct value (country, plan, status).
  • Continuous color mode — a gradient along a numeric field (revenue, score).

Size by

sizeField is optional. Larger numbers draw larger markers.

Chart options

Show legend (or Show color scale in continuous mode) is on by default.

Example query

SELECT
  sessions,
  conversion_rate,
  country,
  revenue
FROM landing_pages
WHERE account_id = :customer_id

Map X to sessions, Y to conversion_rate, Color to country, Size to revenue.

  • Histogram for the distribution of a single number
  • Line chart for an ordered series rather than a cloud of points