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.
The function can only be used in dashboard.
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.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy