Extract first transitioned status

Questions & Answers
1

Hello,
Is it possible to extract the first status a ticket was transitioned to after the CREATE?

Thanks,
Yaron

2

Hi,
You could try creating a new calcualted measure with text output format using this formula:

CASE WHEN
Not IsEmpty([Measures].[Issue created date])
THEN
Generate(
  Order(
  Filter(
  DescendantsSet(
    [Transition Status].CurrenthierarchyMember,
    [Transition Status].[Transition Status]
  ),
  ([Measures].[Transitions to status],
  [Time].CurrentHierarchy.DefaultMember)
  >0
  AND
  DateCompare(
    [Measures].[Issue created date],
    [Measures].[Transition to status first date]
  )<0
  ),
  [Measures].[Transition to status first date],
  BASC
  ).item(0),
  Cast([Transition Status].CurrentHierarchyMember.getcaption as string),
  ","
)
END

If you notice this calculation is slow, you can try using custom Javascript code when defining a new account-specific calculated field and import the fisrt status from issue changelog into a new property for each issue

Martins / eazyBI

image
image2256×1246 353 KB

image
image2314×1370 183 KB

3

Looks good.

Thank you very much.

1 Like