Hi Experts,
I am trying to create a custom status for EPIC based on JIRA-status and assigned. I was able to do most of my requirement but got stuck on one. Could anyone please help…
Where I am stuck : I am not able to find capture the condition to find when issue is unassigned. I tried [Measures].[Issue assignee] = ‘(unassigned)’) but it dint work.
CASE
WHEN [Measures].[Issue type] = “Epic”
THEN
(
CASE
WHEN ([Measures].[Issue status] = “Open” AND [Measures].[Issue assignee] = ‘(unassigned)’) THEN “Not Started”
WHEN ([Measures].[Issue status] = “Open” AND [Measures].[Issue assignee] <> “”) THEN “With PO”
WHEN [Measures].[Issue status] = "Reopened" THEN "With PO"
WHEN [Measures].[Issue status] = "In Progress" THEN "Development Queue"
....
END
)