Several months ago some of my development teams began using the Thoughtworks Mingle application for agile project management. Yes I know that typical agile techniques involve walls and index cards. Frankly I prefer web pages and drag and drop. Mingle does both very well.
As I’ve immersed myself in Mingle, I have really come to enjoy its flexibility. But, a few things have bugged me about some of the charting options…or at least how they’ve been deployed at my organization. My major complaint is that the charts and tables on the Overview page require too much manual intervention to update (read: frequent edits have to be made to the page for new sprints, releases, etc.). Don’t take this as a criticism of Mingle per se, as I can’t fault the Mingle team for the way we’ve implemented it.
It’s become one of my missions to improve the Overview page and create more dynamic charts. My first attempt at this is the creation of a dynamic Velocity per Sprint table:

As you can see, this table contains three elements:
- Planning – Sprint
- Sum Final Estimate – Planning: a summary of a story’s Final Estimate – Planning field, which for us represents the estimated points involved in the story.
- Planning – Release: the release name.
Originally, this was a static table that had to be updated every time we created a sprint…not good. To make this dynamic, I created the following table query:
{% dashboard-half-panel %}
{% panel-heading %}Velocity Per Sprint{% panel-heading %}
{% panel-content %}
{{
table query: SELECT ‘Planning – Sprint’, SUM(‘Final Estimate – planning’), ‘Planning – Release’ WHERE Status = ‘Accepted’ and ‘Planning – Sprint’ !=NULL GROUP BY ‘Planning – Sprint’
}}
{% panel-content %}
{% dashboard-half-panel %}
In future blogs, I’ll share some more Mingle tips.
Like this:
Be the first to like this post.
Recent Comments