Keypup

Syntax: <code>FLATTEN(array_field)</code>

Description: Flatten an array field (e.g. labels) to produce one parent record per value in the array. This operator is useful to turn arrays into single values. Aggregation logic can then be applied on those individual values (e.g. <code>COUNT</code> per individual <code>label</code>).

This operator can only be used in dimension formulas, it cannot be used in metric formulas.

<code>FLATTEN(label_names)</code> will produce one parent record per label in the <code>label_names</code> array, with each record having a single label.

<code>FLATTEN(assignee_usernames)</code> will produce one parent record per user in the <code>assignee_usernames</code> array, with each record having a single assignee.

Using <code>FLATTEN(label_names)</code> as dimension and <code>COUNT()</code> as metric will produce a reporting counting the number of time each label has been used across all records.

Using <code>FLATTEN(label_names)</code> as dimension 1, <code>FLATTEN(assignee_usernames)</code> as dimension 2 and <code>COUNT()</code> as metric will produce a reporting counting the number of label+assignee pairs.

- <code>FLATTEN(label_names)</code> will produce one parent record per label in the <code>label_names</code> array, with each record having a single label.
- <code>FLATTEN(assignee_usernames)</code> will produce one parent record per user in the <code>assignee_usernames</code> array, with each record having a single assignee.
- Using <code>FLATTEN(label_names)</code> as dimension and <code>COUNT()</code> as metric will produce a reporting counting the number of time each label has been used across all records.
- Using <code>FLATTEN(label_names)</code> as dimension 1, <code>FLATTEN(assignee_usernames)</code> as dimension 2 and <code>COUNT()</code> as metric will produce a reporting counting the number of label+assignee pairs.