All eazyBI for Jira eazyBI for Confluence Private eazyBI

CumulativeSum

EAZYBI Calculates the sum of visible row values cumulatively.

This function is available on eazyBI Cloud and starting from the eazyBI version 6.5.

Syntax

CumulativeSum(Numeric_expression)

Arguments

Numeric_expression

MDX expression that returns a number

Examples

The following formula will count created issues for rows cumulatively.

CumulativeSum([Measures].[Issues created])

The following formula calculates the % of resolved issues cumulatively. 

CumulativeSum([Measures].[Issues resolved %])

See report example Lead time distribution in our demo account. The measure Cumulative issues resolved % uses this formula added via default calculations: Add calculated > cumulative sum > including empty for measure Issues resolved %

See also