Hi All
Using EazyBI For Jira, is it possible and how do I pull the user/asignee who triggered a specific workflow transition into a single column of a report.
Things ive tried including using
Transitions for pages
Transition Authors as an addition to measures in columns
Measures like Transition from Status/ Transition to status last date
Looking to report on users in a single column, as part of a bigger report without having to do macros/
Thanks for example; now it is clear to me what report you would like to build.
In this case, you may define a new calculated measure which will go through all transition authors who had moved an issue to selected transition status and get Email of each author (email is a user property). In the calculation, I would recommend using function Generate() as one issue may transition to the same status several times:
CASE WHEN
[Measures].[Transitions to status] > 0
THEN
Generate(
--iterate through all transition authors who moved issue to selected transition status
Filter(
[Transition Author].[User].Members,
[Measures].[Transitions to status] > 0),
--for each transition author get user property Email
CoalesceEmpty([Transition Author].CurrentMember.get('Email'),""),
",")
END
In the report, set Issue dimension as rows, new calculated measure and Transition Status dimension as columns.
Note, this solution works for eazyBI for Jira Server where the property Email is available. But in eazyBI for Jira Cloud, a user email is not imported, and therefore solution won’t work as described.