I am new to Easybi. So excuse my ignorance
I want to create a measure that will calculate the Dead Time Average for each month.
Currently, I always get the same number for each month:
I have created the following:
My created Measures:
[Measures].dead time average
[Measures].[dead time] > 0
[Measures].[created at with time], [Measures].[first assignee date]
[Measures].[created at with time]
[Measures].[first assignee date]
[Measures].[Transition from first timestamp],
The calculated measure returns the same result because all calculation elements ignore the current Time dimension member. The issue property “created at with time” is not tied to the Time dimension, and the “first assignee date” references the Time dimension default member.
Also, I don’t recommend iterating through the Issue dimension “Issue” level members with the particular expression. Instead, use the
Descendants() function and use an issue property as the first filter condition, a numeric measure to tie the calculation to the report context.
Suppose you want to tie the result to the issue creation date on the Time dimension. In that case, the calculated measure formula would look similar to the one below:
-- issue created in Time dimension period
-- issue assignee has changed
([Measures].[Transitions from assignee],
[Time].CurrentHierarchy.DefaultMember) > 0
Please look at our documentation page for more information on defining calculated measures - Calculated measures and members.
Roberts // email@example.com
Thank you very much for your detailed help.