I created a measure to sum the ‘Average workdays in transition status’ so we can see our in progress cycle time for specific transitions like development, Testing(QA) and Blocked. The drill into issue is showing no data or occasionally will drill into issue but there are very few, like 5 when there should be 100.
Ultimately the problem is that leadership does not want to see the average of all the average in progress and wants each status category average to add up together to provide a average number of workdays the team takes each sprint for time in ransitions like development, Testing(QA) and Blocked.