Last User that resolved a ticket

I need to know how to display in my report last user that transioned a ticket to Resolved status.

Please help me on that,
Fabio

Hi, @fabio.racobaldo

Welcome back to the eazyBI community.

To see the last user who transitions the ticket to Resolved status, please use historical ( issue change history) dimensions and measures: Transition Statuss and Transition Author dimensions and Transition to last timestamp measures. Please read more about Issue change history measures and dimensions here: Import issue change history

Also, to take the last change, please consider using Ordering first and then taking the list item using Tail.

The formula for the last who changed the status to Done might look something like this:

CASE WHEN 
      ([Measures].[Transition to last timestamp],
      [Transition Status].[Done])> 0
THEN
Order(
  --set of all transition authors who  transitioned to status Done
  Filter(
    DescendantsSet([Transition Author].CurrentMember,[Transition Author].[User]),
    [Transition Author].CurrentMember.Name <> "(none)" AND
      ([Measures].[Transition to last timestamp],
      [Transition Status].[Done])> 0
  ),
  --order change authors by last change date
  ([Measures].[Transition to last timestamp],
    [Transition Status].[Done]),
  BDESC
--show the latest author
).item(0).GetCaption
END

If you need to set more than one Status, please define the calculated member in the Transition Status dimension using the Aggregate function.

Kindly,
Ilze support@eazybi.com