ratio

ratio, function

def nosort process ratio(a: boolean): number
def nosort process ratio(a: number): number
def nosort process ratio(a: text): number

Returns the fraction of values in a that are true, non-zero, or non-empty depending on the input type.

• a: the values to test within each group.

Examples

table T = with
  [| as A, as G |]
  [| false, "a" |]
  [| true,  "a" |]
  [| false, "b" |]
  [| true,  "b" |]
  [| true,  "c" |]

table G[gdim] = by T.G

show table "Ratio of true values" with
  gdim
  ratio(T.A) as "Ratio"
  group by gdim

This outputs the following table:

table U = with
  [| as A, as G |]
  [| "",    "a" |]
  [| "foo", "a" |]
  [| "",    "b" |]
  [| "foo", "b" |]
  [| "foo", "c" |]

table G[gdim] = by U.G

show table "Ratio of non-empty values" with
  gdim
  ratio(U.A) as "Ratio"
  group by gdim

This outputs the following table:

Remarks

The aggregator returns 1 on empty groups.