We are creating a report which need to use the Issue History to display the following information as a column:
User who moved issue from Status A to Status B
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.
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.
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.
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:
Hi @zane.baranovska Below measure gives the latest transition date transitioning from particular status to specific status. How to get the latest transition date for issues moving from Any Status to specific status?
([Measures].[Transition from status last date],
[Transition].[Backlog => In Progress],
[Time].CurrentHierarchy.DefaultMember)
@prakash_ps, you might want to use the dimension “Transition Status” with the measure “Transition to status last date” to get the latest transition to specified status.
For example:
([Measures].[Transition to status last date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember)
Thank you very much for this post. When I implement the proposed solution, I get time-stamps formats instead of the users. Do you possibly have any idea why this might happen?
@Hendri, eazyBI tries to guess what is the data type for the calculated measure based on measures and properties in the formula. In a few cases, when the formula refers to the date, eazyBI sets the calculation data type to date as well.
