Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

​
atoti.agg.std(operand: LevelOrVariableColumnConvertible, /, *, mode: Literal[‘sample’, ‘population’] = ‘sample’) → MeasureDefinition

​
atoti.agg.std(operand: VariableMeasureConvertible, /, *, mode: Literal[‘sample’, ‘population’] = ‘sample’, scope: CumulativeScope | SiblingsScope | OriginScope) → MeasureDefinition

Return a measure equal to the standard deviation of the passed operand across the specified scope.
  • Parameters:
    • operand – The operand to get the standard deviation of.
    • mode – One of the supported modes:
      • The sample standard deviation, similar to Excel’s STDEV.S, is ∑i=1n(Xi−m)2n−1\sqrt{\frac{\sum_{i=1}^{n} (X_i - m)^{2}}{n - 1}} where m is the sample mean and n the size of the sample. Use this mode if the data represents a sample of the population.
      • The population standard deviation, similar to Excel’s STDEV.P is ∑i=1n(Xi−m)2n\sqrt{\frac{\sum_{i=1}^{n}(X_i - m)^{2}}{n}} where m is the mean of the Xi elements and n the size of the population. Use this mode if the data represents the entire population.
    • scope – The aggregation scope.