GROUP_JACCARD_DIST

Syntax

GROUP_JACCARD_DIST(<string>)

Description

Computes the Jaccard distance of all values in a group. The Jaccard distance between two sets is the ratio of the size of their intersection to the size of their union. For example, the Jaccard distance between two species is 1-(number of regions where both species are present)/(number of regions where at least one species is present).

This is an aggregate function.

Example

Given the following data:

First create a group using GROUPBY(#RawData!Groups)

Then use the GROUP_JACCARD_DIST(#RawData!Letters), and the result is the Jaccard distance of the group created from the column in relation to the GROUPBY() column.