How to get who updated the Issue last time?

I need to get information for Issues in eazyBI that who updated the issue at last? This update can be in terms of status update, comment, or transition.

1 Like

Hi @kuldeep.u,

eazyBI imports the issue field “Updates” as a measure “Issues last updated” and property “Issue updated date” (see the documentation for measure description Jira Core measures and dimensions). However, more details on who performed the update are collected only for standard single select fields, like transition status, assignee, issue type, priority and resolution, and single select custom fields with imported change history.

For analyzing changes in those fields, you might want to create a new calculated measure and use the dimension “Transition Author” and hidden measure “Transition to”. THe expression might look like this:

Order(
  --set of all transition authors who made any changes to issue
  Filter(
    DescendantsSet([Transition Author].CurrentMember,[Transition Author].[User]),
    [Transition Author].CurrentMember.Name <> "(none)" AND
    DefaultContext(
      ([Measures].[Transitions to],
      [Transition Author].CurrentHierarchyMember,
      [Issue].CurrentHierarchyMember)
    ) > 0
  ),
  --order authors by last change date
  DefaultContext((
    [Measures].[Transition to last timestamp],
    [Transition Author].CurrentHierarchyMember,
    [Issue].CurrentHierarchyMember)),
  BDESC
--show the latest author name
).item(0).GetCaption

You might want to check out this community post on how to import more user interactions with issues, including comments:

Consder creating a similar solution by importing only the latest history or comment author name, not all interactions.

Best,
Zane / support@eazyBI.com