Below is the list of functions that are available to use in our "custom story item" bullet: 

Average
Function syntax: Average(dimension, measure, filterDimensionValue)
Description: The average value of the given measure.
MinLabel
Function syntax: MinLabel(dimension, measure, filterDimensionValue)
Description: The name of the entity with the minimum value for the given measure.
MinValue
Function syntax: MinValue(dimension, measure, filterDimensionValue)
Description: The minimum value for the given measure.
MaxLabel
Function syntax: MaxLabel(dimension, measure, filterDimensionValue)
Description: The name of the entity with the maximum value for the given measure.
MaxValue
Function syntax: MaxValue(measure)
Description: The maximum value for the given measure.
Label
Function syntax: Label(measure)
Description: The label for the given measure.
Total
Function syntax: Total(dimension, measure, filterDimensionValue)
Description: The sum total value for the given measure.
Range
Function syntax: Range(dimension, measure, filterDimensionValue)
Description: The difference between the maximum and minimum values for the given measure.
StdDev
Function syntax: StdDev(dimension, measure, filterDimensionValue)
Description: The standard deviation value for the given measure.
Median
Function syntax: Median(dimension, measure, filterDimensionValue)
Description: The median value for the given measure.
Z-Score
Function syntax: Z-Score(dimension, measure, firstDimensionValue, filerDimensionValue)
Description: The z-score for the given measure.
DifferenceFromMean
Function syntax: DifferenceFromMean(dimension, measure, firstDimensionValue, filerDimensionValue)
Description: The difference between the mean and the measure value for the given dimension value.
Difference
Function syntax: Difference(dimension, measure, firstDimensionValue, secondDimensionValue, filerDimensionValue)
Description: The difference in measure values between the two provided dimension values.
PercentDifference
Function syntax: PercentDifference(dimension, measure, firstDimensionValue, secondDimensionValue, filerDimensionValue)
Description: The percent difference in measure values between the two provided dimension values.
Sum
Function syntax: Sum(dimension, measure, firstDimensionValue, secondDimensionValue, filerDimensionValue)
Description: The sum of measure values for the two provided dimension values.
StartingValue
Function syntax: StartingValue(measure, filterDimensionValue)
Description: The value at the first period in the series for the given measure.
EndingValue
Function syntax: EndingValue(measure, filterDimensionValue)
Description: The value at the last period in the series for the given measure.
StartingLabel
Function syntax: StartingLabel()
Description: The name of the first period in the series.
EndingLabel
Function syntax: EndingLabel()
Description: The name of the last period in the series.
StartToFinishDifference
Function syntax: StartToFinishDifference(measure, filterDimensionValue)
Description: The difference between the values for the first and last periods in the given series.
StartToFinishPercentDifference
Function syntax: StartToFinishPercentDifference(measure, filterDimensionValue)
Description: The percent difference between the values for the first and last periods in the given series.
LargestPositiveChangeStartingValue
Function syntax: LargestPositiveChangeStartingValue(measure, filterDimensionValue)
Description: The starting value of the largest positive period-over-period difference, on an absolute basis, in the given series.
LargestPositiveChangeStartingLabel
Function syntax: LargestPositiveChangeStartingLabel(measure, filterDimensionValue)
Description: The name of the starting period for the largest positive period-over-period difference, on an absolute basis, in the given series.
LargestPositiveChangeEndingValue
Function syntax: LargestPositiveChangeEndingValue(measure, filterDimensionValue)
Description: The ending value of the largest positive period-over-period difference, on an absolute basis, in the given series.
LargestPositiveChangeEndingLabel
Function syntax: LargestPositiveChangeEndingLabel(measure, filterDimensionValue)
Description: The name of the ending period for the largest positive period-over-period difference, on a absolute basis, in the given series.
LargestPositiveChangeDifference
Function syntax: LargestPositiveChangeDifference(measure, filterDimensionValue)
Description: The value of the largest positive period-over-period difference, on an absolute basis, in the given series.
LargestPositiveChangePercentDifference
Function syntax: LargestPositiveChangePercentDifference(measure, filterDimensionValue)
Description: The percent change of the largest positive period-over-period difference, on an absolute basis, in the given series.
LargestPositivePercentChangeStartingValue
Function syntax: LargestPositivePercentChangeStartingValue(measure, filterDimensionValue)
Description: The starting value of the largest positive period-over-period difference, on a percentage basis, in the given series.
LargestPositivePercentChangeStartingLabel
Function syntax: LargestPositivePercentChangeStartingLabel(measure, filterDimensionValue)
Description: The name of the starting period for the largest positive period-over-period difference, on a percentage basis, in the given series.
LargestPositivePercentChangeEndingValue
Function syntax: LargestPositivePercentChangeEndingValue(measure, filterDimensionValue)
Description: The ending value of the largest positive period-over-period difference, on a percentage basis, in the given series.
LargestPositivePercentChangeEndingLabel
Function syntax: LargestPositivePercentChangeEndingLabel(measure, filterDimensionValue)
Description: The name of the ending period for the largest positive period-over-period difference, on a percentage basis, in the given series.
LargestPositivePercentChangeDifference
Function syntax: LargestPositivePercentChangeDifference(measure, filterDimensionValue)
Description: The value of the largest positive period-over-period difference, on a percentage basis, in the given series.
LargestPositivePercentChangePercentDifference
Function syntax: LargestPositivePercentChangePercentDifference(measure, filterDimensionValue)
Description: The percent change of the largest positive period-over-period difference, on a percentage basis, in the given series.
LargestNegativeChangeStartingValue
Function syntax: LargestNegativeChangeStartingValue(measure, filterDimensionValue)
Description: The starting value of the largest negative period-over-period difference, on an absolute basis, in the given series.
LargestNegativeChangeStartingLabel
Function syntax: LargestNegativeChangeStartingLabel(measure, filterDimensionValue)
Description: The name of the starting period for the largest negative period-over-period difference, on an absolute basis, in the given series.
LargestNegativeChangeEndingValue
Function syntax: LargestNegativeChangeEndingValue(measure, filterDimensionValue)
Description: The ending value of the largest negative period-over-period difference, on an absolute basis, in the given series.
LargestNegativeChangeEndingLabel
Function syntax: LargestNegativeChangeEndingLabel(measure, filterDimensionValue)
Description: The name of the ending period for the largest negative period-over-period difference, on an absolute basis, in the given series.
LargestNegativeChangeDifference
Function syntax: LargestNegativeChangeDifference(measure, filterDimensionValue)
Description: The value of the largest negative period-over-period difference, on an absolute basis, in the given series.
LargestNegativeChangePercentDifference
Function syntax: LargestNegativeChangePercentDifference(measure, filterDimensionValue)
Description: The percent change of the largest negative period-over-period difference, on an absolute basis, in the given series.
LargestNegativePercentChangeStartingValue
Function syntax: LargestNegativePercentChangeStartingValue(measure, filterDimensionValue)
Description: The starting value of the largest negative period-over-period difference, on a percentage basis, in the given series.
LargestNegativePercentChangeStartingLabel
Function syntax: LargestNegativePercentChangeStartingLabel(measure, filterDimensionValue)
Description: The name of the starting period for the largest negative period-over-period difference, on a percentage basis, in the given series.
LargestNegativePercentChangeEndingValue
Function syntax: LargestNegativePercentChangeEndingValue(measure, filterDimensionValue)
Description: The ending value of the largest negative period-over-period difference, on a percentage basis, in the given series.
LargestNegativePercentChangeEndingLabel
Function syntax: LargestNegativePercentChangeEndingLabel(measure, filterDimensionValue)
Description: The name of the ending period for the largest negative period-over-period difference, on a percentage basis, in the given series.
LargestNegativePercentChangeDifference
Function syntax: LargestNegativePercentChangeDifference(measure, filterDimensionValue)
Description: The value of the largest negative period-over-period difference, on a percentage basis, in the given series.
LargestNegativePercentChangePercentDifference
Function syntax: LargestNegativePercentChangePercentDifference(measure, filterDimensionValue)
Description: The percent change of the largest negative period-over-period difference, on a percentage basis, in the given series.
LongestStreakStartingValue
Function syntax: LongestStreakStartingValue(measure, filterDimensionValue)
Description: The starting value of the longest streak of consecutive increases or decreases for the given series.
LongestStreakStartingLabel
Function syntax: LongestStreakStartingLabel(measure, filterDimensionValue)
Description: The name of the starting period for the longest streak of consecutive increases or decreases for the given series.
LongestStreakEndingValue
Function syntax: LongestStreakEndingValue(measure, filterDimensionValue)
Description: The ending value of the longest streak of consecutive increases or decreases for the given series.
LongestStreakEndingLabel
Function syntax: LongestStreakEndingLabel(measure, filterDimensionValue)
Description: The name of the ending period for the longest streak of consecutive increases or decreases for the given series.
LongestStreakDifference
Function syntax: LongestStreakDifference(measure, filterDimensionValue)
Description: The difference over the longest streak of consecutive increases or decreases for the given series.
LongestStreakPercentDifference
Function syntax: LongestStreakPercentDifference(measure, filterDimensionValue)
Description: The percent difference over the longest streak of consecutive increases or decreases for the given series.
LongestStreakLength
Function syntax: LongestStreakLength(measure, filterDimensionValue)
Description: The largest number of periods of consecutive increase or decrease for the given series.
LongestStreakDirection
Function syntax: LongestStreakDirection(measure, filterDimensionValue)
Description: The direction (positive or negative) of the longest streak of consecutive increases or decreases for the given series.
Value
Function syntax: Value(dimension, measure, dimension value, filterDimensionValue)
Description: The metric value for a given dimension, measure, and dimension value.
Count
Function syntax: Count(dimension)
Description: The number of dimension values within a given dimension.
PeriodLabel
Function syntax: PeriodLabel(index)
Description: The name of the nth period in the series, starting at 1.
PeriodValue
Function syntax: PeriodValue(measure, index, filterDimensionValue)
Description: The value of the given measure at the nth period in the series, starting at 1.
SortDescendingValue
Function syntax: SortDescendingValue(measure, rank, dimension, filterDimensionValue)
Description: The value of the given measure sorted in descending order at the given rank (starting at 1).
SortDescendingLabel
Function syntax: SortDescendingLabel(measure, rank, dimension, filterDimensionValue)
Description: The entity name of the given measure sorted in descending order at the given rank (starting at 1).
SortAscendingValue
Function syntax: SortAscendingValue(measure, rank, dimension, filterDimensionValue)
Description: The value of the given measure sorted in ascending order at the given rank (starting at 1).
SortAscendingLabel
Function syntax: SortAscendingLabel(measure, rank, dimension, filterDimensionValue)
Description: The entity name of the given measure sorted in descending order at the given rank (starting at 1).




Was this article helpful?