Binning functions
Binning is a way to group a number of more or less continuous values into a smaller number of "bins" . For example, if you have data about a group of people, you might want to arrange their ages into a smaller number of age intervals.
Function List:
BinByDateTime(dt, levels, levelIndex)
Groups the values into bins based on a datetime hierarchy.
dt is the DateTime value to bin. levels (string) is the definition of the levels in the DateTime hierarchy. The
hierarchy levels should be written in the form of a string containing the desired date parts, separated by dots, for
example "yy.qq.mm". levelIndex (int) is the pruning level which specifies the level of the hierarchy to
display. levelIndex numbering starts at 0.
Valid arguments for levels are combinations of:
- "yy" - The year.
- "qq" - The quarter.
- "mm" - The month.
- "dy" - The day of year.
- "dd" - The day.
- "wk" - The week.
- "dw" - The weekday.
- "hh" - The hour.
- "mi" - The minute.
- "ss" - The second.
- "ms" - The millisecond.
BinByDateTime(${Age}, "yy.qq.mm", 2)
BinByDateTime(Date(1970, 11, 17), "qq.mm.dd", 0) // 4
BinBySpecificLimits(x, limits)
Groups the values in the column by defined limits for the bins. x is the checked value to bin and the following
arguments are the limits for the bins. limits here is a list of numbers.
BinBySpecificLimits(${Age}, [18, 30, 45, 60, 75])
BinBySpecificLimits(20, [18, 30, 45]) // "18 < x <= 30"