Hi @Arpita_Solanki ,
To calculate the time in statuses, perhaps you could discover issue cycles.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/issue-cycles
It should let you club statuses in custom cycles and then eazyBI would automatically import “Days in cycle” sort of measures for each cycle.
I would recommend watching the following recording from the presentation about issue cycles to better understand how cycles can be used in reports:
https://docs.eazybi.com/eazybi/learn-more/training-videos/training-videos-on-specific-topics#Trainingvideosonspecifictopics-WhereDidtheTimeGo:DiscoverIssueCycles
Check out our demo reports with cycles:
https://eazybi.com/accounts/1000/dashboards/7513-age-lead-and-cycle-time
Martins / eazyBI support