|Expression||MDX expression that typically returns a measure, a tuple, or a string.|
Function ConstantColumnValue is used in default report calculations for the option Add calculated: Average, Median, Min, and Max, % of Total
The formula example below is the standard statistical Median calculation calculated for Average progress days (Issue cycle for Progress category).
See the report example Control chart (Progress cycle) in our demo account. The measure Median Average Progress days created with standard calculation Add calculated > Statistical > Median uses the formula above.
- Add standard calculations based on a selected measure
- Function ConstantValue() works similarly. It is usable if the calculation should be calculated only once per report.
- Function Cache()