Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUP_SORT_DESC(<any>)

Description

Sorts groups in descending order. This can be used for click stream analysis.

This is a group series function.

The sort results can't be guaranteed to transfer from one sheet to another due to the nature of distributed systems. Ensure the sort was made on the sheet where it is being referenced.

Example

Given the following data:

GroupUsers
group15
group18
group29
group17
group19
group212
group210
group24
group12
group16

First create a group using GROUPBY(#RawData!Group).

Group
group1
group2

Then use the GROUP_SORT_DESC(#RawData!Users). The result is the column values displayed in descending order in relation to the GROUPBY() column.

GroupDecending_Users
group19
group18
group17
group16
group15
group12
group212
group210
group29
group24
  • No labels