I just want to find out the time spent in each status by an issue.
Suppose ex. AAA-101 current status is “Done”. But how many days it spent in “To Do”, “In Progress”, “In Review”, “In QA” like this.
It might be gone in same status again and again 2-3 times.
you can use issue change history measures and dimensions to build the report you are looking for.
Add Issues in Rows at Issue level, select Days in transition status measure from Measure dimension and next to Measures in Columns add Transition Status dimension at Status level.
The report would look like this:
But you can explore our demo account to see some other report types that looks at issue age, lead and cycle time - https://eazybi.com/accounts/1000/dashboards/7513-age-lead-and-cycle-time
Gerda // support@eazyBI.com