Hi @CarlyBooth ,
You are correct. The Time dimension does affect the values displayed by measures. Just like the measure “Issues resolved” will display the number of issues resolved in each month, the measure “Days in transition status” will display the number of days an issue spent in particular status in the period it was transitioned out of the status.
In your case, it could be that some issues were transitioned out of the two statuses in a previous Time dimension period to the one it was resolved in. Thus, the “Days in transition status” values will be empty for the two Transition Status members.
I suggest resetting the context of the Time dimension in the two tuples that retrieve the number of days issues spent in particular statuses. See the suggested formula below:
NonZero(Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.get(‘Resolved at’),
[Time].CurrentHierarchyMember
)
and
[Measures].[Issues resolved]>0
),
DateDiffDays(
[Issue].CurrentMember.get(‘Created at’),
[Issue].CurrentMember.get(‘Resolved at’)
)
-
(
[Measures].[Days in transition status],
[Transition Status].[Draft],
[Time].CurrentHierarchy.DefaultMember
)
-
([Measures].[Days in transition status],
[Transition Status].[Live],
[Time].CurrentHierarchy.DefaultMember)
))
This way, the number of days the issues spent in particular statuses will be retrieved, disregarding the current Time dimension member.
See more details on tuples and resetting context here - Calculated measures - eazyBI for Jira.
Best,
Roberts // support@eazybi.com