Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Syntax

GROUPMEDIAN(<number>)

Description

Returns the medium of all values in a group.

This is an aggregate 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 GROUPMEDIAN(#RawData!Participants), and the result is the medium number of the column in relation to the GROUPBY() column.

GroupsParticipants_MEDIAN
group16
group230
  • No labels