I want to see a Report/Table to show the issue assignee for particular period or range of dates. Example (Assignee of the ticket during January or before 3 months etc)
How do we get this report in eazyBI. Could you please help on this?
@ nauris.malitis Could you please help on this?
You could use a similar approach as described in this post: How to list all assignees of an issue - #2 by zane.baranovska. I adopted the formula to show all assignees during the selected period for issues that had assignee changes:
Here is the formula:
--go through all Assignee users
--check wheather user was assignee of the issue during selected period
NOT IsEmpty([Measures].[Issues history]) ),
--get assignee names separated by comma
Lauma / email@example.com