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
