Function Index

CumeDist

Compute the cumulative distribution of the input column. The cumulative distribution is a number between 0 and 1. The last row is always 1.

Usage

CumeDist(<column>,<direction ”asc” | “desc”>)

column (required) The column used to order the table.

direction (optional) The direction to sort the input column. Enter in “asc” to sort ascending and “desc” to sort descending. Default sorting is ascending.

Examples

CumeDist([Population 2010])
CumeDist([COUNTY - Count])