I am looking for solution on how to generate a report which looks like this:
And also hot to get an aggregate data of How much time a developer spend in each status on a sprint level.
Please help
Hi @anurajsl
Welcome to eazyBI community.
In this case, you could use the “Transition Status” dimension in rows, use “Days in transition status” measure for “Time spend in Status” column.
Note this measure would not show the time in the current status, it shows time only for finished cycles.
For “Time” column, you can select the measure “Transition to status last date” which will return the last time issue was sent to the displayed transition status
For “Assignee at the time of status” you could use the “Assignee” dimension which should return the last Assignee for the status.
It will be the assignee at the last date of status
I assume this is a in issue level report otherwise it is not clear how you aggregate the data in your requirement.
Martins / eazyBI support
