MicroStrategy ONE
Standard deviation (of a sample)
Returns the standard deviation of a population based on a sample. The standard deviation is an indicator of how widely values in a group differ from the mean. It is useful for comparing different sets of values with a similar mean. This is a group-value function.
Syntax
StDev<Distinct = False, FactID>(Argument)
-
Distinct is a true/false parameter that allows you to calculate using all values in the list or only the unique values.
-
FactID is a parameter that forces a calculation to take place on a specific fact table containing the FactID.
-
Argument is an attribute, fact, or metric representing a list of numbers.
For additional information on and an example of this function, refer to the Functions Reference.