GROUP_SORT_DESC
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:
Group | Users |
---|---|
group1 | 5 |
group1 | 8 |
group2 | 9 |
group1 | 7 |
group1 | 9 |
group2 | 12 |
group2 | 10 |
group2 | 4 |
group1 | 2 |
group1 | 6 |
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.
Group | Decending_Users |
---|---|
group1 | 9 |
group1 | 8 |
group1 | 7 |
group1 | 6 |
group1 | 5 |
group1 | 2 |
group2 | 12 |
group2 | 10 |
group2 | 9 |
group2 | 4 |