MEDIANCOLUMN |
Description
Returns the median value from a column.
Syntax
MEDIANCOLUMN(value, column1, column2, ...)
Value is the column from which you want to find the median value. Value can be a number or date column.
Column1, column2,... are up to 30 optional columns that define the aggregation context. The median value is returned for each unique combination of the group_by columns.
When the result of MEDIANCOLUMN is given as the final value for a new column in a transform worksheet, as in the example below, each row will get the value of MEDIANCOLUMN that corresponds to its particular aggregate values.
If no group_by columns are provided, the median value in the entire column is returned.
Example
In the following we see how MEDIANCOLUMN works with a numeric column and a single aggregation column. The calculated value is entered in each row.
SampleData
UnitSales
| Store
| =MINCOLUMN(UnitSales,Store) | NUMBER
| TEXT
| NUMBER
| 157
| West | 157
| 127
| Central
| 114.5
| 102
| Central | 114.5
| 353
| North
| 353
| 104
| East
| 104.5
| 105
| East
| 104.5
|
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
