Need date Jira ticket first assigned in eazyBI

Blanca Quiroz

Hello, 

 

All I need is the date the ticket was first assigned to a user. 

 

Any help?

Martins Vanags_eazyBI

Hi,

 

In this case, first, you could ensure that issue change history is imported.

Next, you could define a new calculated member in "Measures" dimension using the following code and one of "date" formatting options:

 

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

 

Martins / eazyBI support,