My cards have a status with values like “in analysis”, “in dev”, “in testing”, “complete”

Is it possible to calculate when analysis/dev/testing completed based on when the status of a card changed?

The only way to track this that I know of is by creating separate properties for each of these: “analysis completed iteration”, “dev completed iteration”, etc. I would prefer not to do this because it is a lot of manual work and it is very error prone. Since my mingle database already has much of the information necessary to calculate this, I shouldn’t have to.

I could imagine formulas like: “analysis completed date” = last date that status changed from “in analysis”
and “analysis completed iteration” = iteration card where “analysis completed date” between “iteration start date” and “iteration completed date”

—Rolf

I posted on how I did something similar. Basically, I retroactively added these status change dates to my mingle db so I could show burn up charts. Here’s my post on the subject: http://blog.eleutian.com/CategoryView,category,mingle.aspx

If they delete the link, just google/i’m feeling lucky “adding burn up charts to mingle”