Lead time for issue types from status C to G

[gerda.grantina]

Hi @Dilan ,
You can check out example reports in eazyBI demo dashboard Age Lead, and Cycle Time. It represents different cases.
You can read more about it here in this answer provided by Daina:

Calculate Lead/Cycle Time From Specific Statuses

You would like to check out our example reports in our demo accounts for Cycle and Lead times. We set a dashboard Age Lead, and Cycle Time there to represent different cases. Here are some measures I would like to point as examples: Cycle time for a specific set of statuses for resolved issues and measure Rolling average cycle time in particular. This measure contains two approaches. The formula by default works for any statuses in status category In Progress. There is an alternative solution …

Also, check this answer from Martins on how to calculate average time based on status transition:

Avg days between two statuses

@joejames Try this code: CASE WHEN ( [Measures].[Transitions to status], [Transition Status].[Waiting for Production] ) > 0 THEN AVG( Filter( Descendants([Issue].CurrentMember, [Issue].[Issue]), ( [Measures].[Transitions to status], [Transition Status].[Waiting for Production] ) > 0 ), DateDiffDays( ( [Measures].[Transition to status first date], [Transition Status].[In Progress], [Time].CurrentHierarchy.DefaultMember…

best,
Gerda // support@eazyBI.com