Skip to main content
On this page

Kater SQL Functions Derive

Derive

These functions put values into groups, give them new labels, or count the periods between two dates.

The Derive menu writes them. See Groups and flags.

FunctionWhat it does
KATER__MAPA label for each value you list, and one label for every other value.
KATER__BUCKETA label for the band of numbers that each value is in.
KATER__PERIODS_SINCEHow many whole periods there are from the since date to this date.