EazyBi - montly rolling average (difference between created and resolved)

zkillingbeck June 29, 2020

On EazyBi I am trying to create a calculated measure for the monthly rolling average of the difference between issues created and issues resolved. Any advice on the formula to use? 

 

1 answer

0 votes
Roberts Čāčus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 25, 2020

Hi @zkillingbeck,

To calculate a rolling average, try creating a new calculated measure with the Avg() function. It requires two parameters - a set expression and a numeric expression.

The numeric expression can be the difference between the issues created and resolved each month. The set expression can be a period of time, for example, three months.

The formula for such a calculation would look similar to the one below:

CASE WHEN
DateCompare(
[Time].CurrentHierarchyMember.StartDate,
Now()
) <= 0
THEN
Avg(
{[Time].CurrentHierarchyMember:
[Time].CurrentHierarchyMember.lag(2)},
([Measures].[Issues created]-[Measures].[Issues resolved])
)
END

Please have a look at the pictures of a sample report below:

Screen Shot 2020-08-25 at 12.52.35.pngScreen Shot 2020-08-25 at 12.53.34.png

Please have a look at our documentation page for more information on defining calculated measures - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.

 

Best,

Roberts // support@eazybi.com

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events