Hi folks,
I would like to create a Report that shows the percentage of issues that changed the issue type (any issue type change) within a certain period.
I would like to filter a certain time period (quarter, month…) and see how many issues have been created , and in how many of these the issue type changed.
I´ve tried using following formula:
(
[Measures].[Transitions from],
[Transition Field].[issuetype],
[Time].Currenthierarchy.CurrentMember
)
But when I chose the Measure “issues created” the number of issues created is not correct (is lower that the number of issues with changes).
Many thanks in advance!
1 Like
Hi,
I will share a summary of our direct communication so other community members can benefit from the information as well:
If you have a filter on Issue type in your report, it will affect measures “Issues created” and “Transitions from” differently.
“Issues created” is a regular measure that shows the count of issues created each week by their current issue type (e.g., Incident), regardless of any changes made or not.
On the other hand, "Transitions from " is a historical measure and it looks at Issue type at the moment of transition away from specific issue type (and it is true that those issues are currently not Incidents anymore).
Best,
Ilze
1 Like