Overview
Syntax | MEDIAN_AGG(Array) | According to the current analysis dimension, this function returns the median of the field. The generated results are listed in a data column. The number of rows in the data column is consistent with that in the current analysis dimension. |
Parameter | Array | The Array parameter must be the result returned by a non-aggregate function formula, which can be a calculation result of an indicator field, dimension or indicator field and a common formula. The Array parameter does not support date or text parameters. |
Notes
The function can only be used in dashboard.
Example
If the horizontal axis is the dimension field Day, the value returned by the calculation field MEDIAN_AGG(Sales Volume) of the vertical axis is the median sales per day.
If the dimension field in the lateral axis is Month, the value returned by the calculation field MEDIAN_AGG(Sales Volume) is the median sales per month.
1. For example, if you want to calculate the median of Contract Amount per year, you can use the formula MEDIAN_AGG(Contract Amount), as shown in the following figure.
2. If the current analysis dimension of Contract Signing Date is changed to Year - Month, the median of Contract Amount per month will be displayed, as shown in the following figure.
Previous：MAX_AGG - Returning the Maximum Value of a Field
