New to these forums, thanks in advance. I am trying to create the MDX formula for a measure that sums the total # of times an issue in JIRA has been set to a specific status.
I’ve gotten as far as this (see below). It is pulling every status transition from the ‘Pending’ status to another status. This is partially correct based on our workflow, but it is pulling all status transitions from ‘pending.’ I only want it to show the number of times an issue has been sent specifically to ‘In Progress1.’ Every other MDX combination I tried broke the formula or removed the measure from the table entirely. What am I missing?
([Measures].[Transitions to status], [Transition Status].[Pending])
[Transition to Status].[In Progress2]