Functions

Every function a formula can call, the nine number functions and the ten charts.

A function folds references into a value or draws them as a chart. Function names are case-insensitive. Where a function wants a single number (a scalar), passing a range is an error.

Number functions

SUM

number

SUM(range or values) → number

Adds the numbers. Blanks drop out. An empty set is 0.

AVG

number

AVG(range or values) → number

The mean of the numbers. An empty set is blank.

MIN

number

MIN(range or values) → number

The smallest number. An empty set is blank.

MAX

number

MAX(range or values) → number

The largest number. An empty set is blank.

COUNT

number

COUNT(range or values) → number

How many numbers there are. Blanks are not counted.

MEDIAN

number

MEDIAN(range or values) → number

The middle number, or the mean of the two middle numbers.

FIRST

number

FIRST(range) → number

The first number in the series.

LAST

number

LAST(range) → number

The last number in the series.

ROUND

number

ROUND(number, places?) → number

Rounds a number to a number of decimal places.

numbernumberrequired

The value to round.

placesnumberdefault 0

Decimal places.

Chart functions

Each returns an inline chart drawn from its arguments. Every one is drawn live by the same renderer the cells and cards use.

SPARKLINE

BARS

WATERFALL

BUMP

HORIZON

LIKERT

+200%

DELTA

BULLET

PROGRESS

HEATCELL

SPARKLINE

chart

SPARKLINE(range) → chart

A line of the series.

BARS

chart

BARS(range) → chart

Bars of the series.

DELTA

chart

DELTA(now, before?) → chart

A value against a previous one.

nownumberrequired

The current value.

beforenumber

What to compare it against.

BULLET

chart

BULLET(value, target?) → chart

A value against a target.

valuenumberrequired

The value.

targetnumber

The target to mark.

PROGRESS

chart

PROGRESS(value, of?) → chart

A value as a share of a whole.

valuenumberrequired

The value.

ofnumber

The maximum (the whole).

HEATCELL

chart

HEATCELL(value, low?, high?) → chart

A value as a shaded cell. Give both low and high to fix the scale. Otherwise it scales to the value.

valuenumberrequired

The value.

lownumber

The bottom of the scale.

highnumber

The top of the scale.

WATERFALL

chart

WATERFALL(range) → chart

The series as rising and falling steps.

BUMP

chart

BUMP(range) → chart

The series as a rank line.

HORIZON

chart

HORIZON(range) → chart

The series as a compact horizon band.

LIKERT

chart

LIKERT(range) → chart

The series as a diverging Likert strip.

Formulas inside a sentence

A card's sentence layout takes prose with {...} slots. Text outside braces stays text. Each {=formula} slot is run and drawn in place. An unclosed { is treated as plain text.

The team shipped {=SUM([Weekly check-ins.Shipped])} this quarter.