Measure about when an issue was assigned

Questions & Answers
1

I’m looking for a measure about WHEN an ISSUE transitioned from UNASSIGNED to having an ASSIGNEE (doesn’t matter who the assignee is).

I’m doing a bar/gantt chart with the following data:

  • Issue created date (predefined measure)
    [Issue].CurrentHierarchyMember.get(‘Created at’)
    - DRAFT to TO DO Date (Defined measure)
    ** ([Transition].[Draft => To Do],[Measures].[Transition to status last date])**
  • IN PROGRESS Date (Defined measure)
    ([Transition].[To Do => In Progress],[Measures].[Transition to status last date])
  • DONE Date (Defined measure)
    ([Transition].[In Progress => Done],[Measures].[Transition to status last date])

I want to replace the DRAFT to TO DO with the measure I’m looking for.

2

Hi @HRivest

Welcome to the eazyBI Community!

If you’d like to return the first date issue got assigned to anyone, you may consider using the below Tuple function (also explained here in our documentation Page - TimestampToDate)

TimestampToDate(
  (
    [Measures].[Transition to first timestamp],
    [Transition Field].[Assignee]
  )
)

Best wishes,

Elita from support@eazybi.com

1 Like
3

It is odd, the timestamp date measure works for some, but in other it looks like it doesn’t work as it doesn’t provide a date, and the issues were assigned to someone. :face_with_raised_eyebrow:

I can’t figure out why it doesn’t work for all the issues though. Any ideas?

4

Hello @HRivest

Thanks for the follow-up!
Are you using any report filters? For example Time dimension in Pages?

Best wishes,

Elita from support@eazybi.com

1 Like
5

That was exactly why… I wanted to see only the issues in the current fiscal year… but some issues started in a past fiscal year… Thanks!

1 Like