Hi guys
I’m trying created a view of workflow that shows the number of impediment happended when an issues was in specific status
To do this i could use issue status when it was flagged as impediment
Can you guys help me?
I tryed this, but it didn’t work:
CASE
WHEN [Measures].[Issue Flagged] > 0
THEN
[Measures].[Transition to status last date]
END
I can imagine the output like below, where i can see a total of times an issues flagged impediment when it was in that status
This could help me to see where are the bottlenecks
Hi, @Diego_Marcos_Ribeiro
Welcome back to the eazyBI community.
If you use Jira Software (the former Jira Agile add-on) then the Flagged field is available in the Jira import options under the custom fields selection. Please read more here: Jira Software custom fields
I suggest using the tuple to see how many issues have been marked as Flagged in each status. Please read more about tuple here: Tuple
To see the count of the Flagged issue, please use the measure “Transitions to issues count”, read more here: Import issue change history
The formula might look something like this:
(
[Measures].[Transitions to issues count],
[Flagged].[Impediment]
)
If using the Issue change history, use the measure together with the Transition Status dimension.
Kindly,
Ilze