Timeline of Custom Field Change

Hi @Mert_Calisan

Is this Jira custom field a single choice field or a multiple-choice field? If it is a multiple-choice field that contains multiple values per issue then it is not possible to import history for it.

If it is a single choice field and you have the Import change history enabled and added code in your Advanced settings to import the change history for this custom field then you can define a new calculated measure with formula along these lines:

TimestampToDate(
  (
    [Measures].[Transition to last timestamp],
    [Transition field].[Automation Status]
  )
)

Make sure to set the formatting to “Date”.
In the Issue member level, this measure will return the last date that the Automation Status field was changed for this issue. You can also change the formula to return [Transition to first timestamp] to get the first date, that an Issue had this field assigned.

Best regards,
Nauris / eazyBI support

1 Like