Measure to show Transition Author and Transition Date

We are creating a report which need to use the Issue History to display the following information as a column:

  1. User who moved issue from Status A to Status B
  2. Date on which issue moved from Status A to Status B
Fix Version Issue Issue Transition Author Issue Transition Date
2020.10.0.0 ABC-1 XYZ 3/10/2020
2020.10.0.0 ABC-2 ABC 2/11/2020
2020.10.0.0 ABC-3 XYZ 3/10/2020
2020.10.0.0 ABC-4 ABC 2/11/2020

This report will be auto exported to another system for further reporting, hence we cannot use the combination of dimension and mesasure. We are open to using a Javascipt to create a field during import and using it as an Issue property.

Hi @knayak!

The easiest way, and in some level necessary to have each row for each issue and author, would be to cross-join all the dimensions you are interested in, similarly as:

I noticed though that you have not mentioned Transition Status, so the example above shows any transition first and last date done by those authors.

Also, could you please specify in more detail what format you wish to export this to?
If you export to CSV, the columns will not be merged, so the above format might work for you.

Lauma / support@eazybi.com

we want to show the data for a specific transition. for example the user who move the issue from Backlog to In Progress and the date the move happened.

basically trying to create a 2 calculated measures that will get me the author and date.

Hi @knayak,

You can define calculated measures that get the name of a user who made the last transition as well as the date of that transition.

To get the latest transition date, you might use a tuple of measure “Transition from status last date” and particular Transition from Backlog to In Progress.

([Measures].[Transition from status last date],
[Transition].[Backlog => In Progress],
[Time].CurrentHierarchy.DefaultMember)

To get the user name, you might want to look at transition authors who moved issues between states and pic the latest author. The principle for calculation is to filter transition authors that had made a particular transition and validate if it is the latest transition between those statuses. If so, then get a user name.
The formula to get a user who moved an issue from Backlog to In Progress might look like this:

Generate(
  --fiter set of transition autors
  Filter([Transition Author].[User].Members,
    --user is the author of the last transition
    Iif( 
      --if date when user made transition
      DateToTimestamp(([Measures].[Transition from status last date],
        [Transition].[Selected for Development => In Progress],
        [Time].CurrentHierarchy.DefaultMember)) = 
      --matches the date of the latest transition
      DateToTimestamp(([Measures].[Transition from status last date],
        [Transition].[Selected for Development => In Progress],
        [Time].CurrentHierarchy.DefaultMember,
        [Transition Author].DefaultMember))
      --then get the transition author
      ,1,0) > 0)
    ,
  --and return user name
  [Transition Author].CurrentMember.Name, ","
)

You may also check out the community post with another example of how to list users who have made particular changes to issue:

Best,
Zane / support@eazyBI.com