Thanks Zane. I’ve now resolved that problem. I’m working on a new calculation, could you help have a look? See screen shot below, I’m trying to calculate that, on average, how many days were spent in each of the transition status. For e.g. on average, how many days were cost in “Clarify” status, f…

@Leon , you figured it out correctly, in the calculation should be measure Transitions from status issues count. Thank you for noticing that! I fixed the formula in my answer. We keep one topic in one thread to allow users search for solutions and keep Community topics in order, If you have a new q…

How many days on average were spent in each of the transition status

Questions & Answers

Leon April 1, 2019, 5:47am 6

Thanks Zane.

I actually just opened a new one below; would you kindly help?

Regards,
Leon Li