This is an alpha release of FnordMetric. Expect bugs and vulnerabilities.

Edit this page on GitHub

Point Charts

The syntax for pointcharts is:

DRAW POINTCHART
    [ [ WITH ]
          common_chart_options ]

2D Point Charts

All 2D Point Chart series must have at least two columns: x and y. A 2D Point Chart will draw one point at (x, y) for each input row.

The type of the x column can be any of String, DateTime, Numeric. The type of the y column can be any of String, DateTime, Numeric.

Parameters:

x (mandatory) the x axis value, type can be any of String, DateTime, Numeric
y (mandatory) the y axis value, type can be any of String, DateTime, Numeric
series (optional) if set, each series will be displayed as a distinct collection of points (i.e. in a different color)
pointstyle (optional) the point style, valid values are circle and none. default: none
pointsize (optional) the line width in pixel. default: 4
label (optional) a label to be displayed above each point
color (optional) the line/point color (hex value, eg. #ff0000)

3D Point Charts

All 3D Point Chart series must have at least three columns: x, y and z. A 3D Point Chart will draw one point at (x, y) with size z for each input row.

The type of the x column can be any of String, DateTime, Numeric. The type of the y column can be any of String, DateTime, Numeric. The type of the z column must be Numeric.

Parameters:

x (mandatory) the x axis value, type can be any of String, DateTime, Numeric
y (mandatory) the y axis value, type can be any of String, DateTime, Numeric
z (mandatory) the point size, type must be Numeric
series (optional) if set, each series will be displayed as a distinct collection of points (i.e. in a different color)
pointstyle (optional) the point style, valid values are circle and none. default: none
label (optional) a label to be displayed above each point
color (optional) the line/point color (hex value, eg. #ff0000)

Examples

2D Point Chart:

IMPORT TABLE example_data
   FROM 'csv:examples/data/point_example.csv?headers=true';

DRAW POINTCHART WITH
   AXIS BOTTOM
   AXIS LEFT
   AXIS TOP
   AXIS RIGHT
   GRID HORIZONTAL VERTICAL;

SELECT series AS series, x AS x, y AS y
   FROM example_data;

3D Point Chart with Labels:

IMPORT TABLE example_data
   FROM 'csv:examples/data/point_example.csv?headers=true';

DRAW POINTCHART WITH
   AXIS BOTTOM
   AXIS LEFT
   AXIS TOP
   AXIS RIGHT
   YDOMAIN -40, 60
   LABELS;

SELECT series AS series, x AS x, y AS y, z as z, z as label
   FROM example_data;