Create a report showing users who worked on a ticket

Paul Benati

I have a JSD Next Gen project, SERVICE, and want to create a report that shows all users who worked on the ticket.  Worked on the ticket is defined as:

1. were assigned to the ticket,
2. were Request participants on the ticket,
   or,
3. commented on the ticket.

I'd like the report to look something like this:

Issue     | Assignees           | Request participants | Commentors

SERVICE-1 | A Doe, B Doe, C Doe | B Doe, D Doe         | A Doe, B Doe

SERVICE-2 | E Doe, F Doe, A Doe | C Doe, G Doe, H Doe  | A Doe, G Doe, H Doe

Any help would be appreciated!

Thanks,

Paul

Daina Tupule eazyBI

I would suggest using the calculated JavaScript custom field to track Activity in the issue. The solution could show you anyone working on the issue, including comments. The formula maps users to Assignee dimension. It would be easier to use one dimension to see all the contributions to the ticket.

 

Here is a post in the eazyBI community portal with Activity history data import. You can use the solution as it is or add some filters to log specified change activities only.

 

Daina / support@eazybi.com