Skip to main content
MEDIAN

Get the median value of a specified numeric field within a range or partition

Updated over a month ago

Description

The MEDIAN() function returns the median value of a specified numeric field within a range or partition. This is useful for identifying the central value.

Syntax

MEDIAN(number)

Output

numeric

Variables

  1. number: the numeric field to be medianed.

Example

MEDIAN(Value) Over (Partition by Group)

ID

Group

Value

MEDIAN

1

A

10

15

2

A

20

15

3

A

15

15

4

B

30

35

5

B

40

35

Did this answer your question?