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?
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.