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

Syntax

GROUPBOTTOMN(<any>;[<integer>])

Description

Selects the bottom N values from a group. If this function is applied on a date column, bottom N means the N least recent dates.

This is a group series function.

Example

Given the following data:

GroupsParticipants
group16
group112
group15
group15
group15
group17
group15
group19
group18
group224
group224
group224
group233
group233
group229
group230
group232
group235

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

Groups
group1
group2

 Then use the GROUPBOTTOMN(#RawData!Participants;3), and the result is the bottom "N" (in this case "3") values of the column in relation to the GROUPBY() column.

GroupsSmallest_Participants
group15
group15
group15
group224
group224
group224
  • No labels