Create a Cumulative Flow Diagram using Greenhopper

Note: I have since discovered that actually this does not produce a perfect cumulative flow diagram as the script doesn’t incorporate negative accumulation. Working on a php script which factors both positive and negative to give an accurate flow.

Ok so after much hunting around I have finally found a solution to creating a cumulative flow diagram using Greenhopper – albeit a workaround!

1) Download Toad for MySQL: http://www.quest.com/toad-for-mysql/

2) Connect to your JIRA Database

3) Use the following query to pull out accumulative totals – tweak parameters based on the project you are working on:

SELECT DATE_FORMAT(changegroup.CREATED, ‘%Y/%m/%d’) AS CountDate, changeitem.NEWSTRING, Count(changeitem.NEWSTRING) As Total
FROM changeitem
left outer JOIN changegroup
ON changeitem.groupid = changegroup.ID
left outer JOIN jiraissue
ON changegroup.issueid = jiraissue.ID
left outer JOIN projectversion
ON jiraissue.PROJECT = projectversion.PROJECT
WHERE jiraissue.PROJECT = ** Your Project ID**
AND changeitem.FIELD = ‘status’
AND projectversion.vname = ‘Release 1′
GROUP BY CountDate, changeitem.NEWSTRING
ORDER BY CountDate ASC

4) Export your result set into Excel and create a pivot table
5) Change the graph to type Area
6) Summaries your results by running total

See Example here

Obstacles Welcome by Ralph de la Vega, 2009

So, it has been two months since my last blogger book review. After my previous read I was looking forward to my next book from Thomas Nelson but unfortunately my expectations weren’t met.

Obstacles Welcome is the story of Ralph de la Vega’s rags to riches progression to becoming the President and CEO of AT&T Mobility. My expectation of the book was a roller coaster story of personal development and growth, but instead it turned out to be a business theory book intertwined with elements of Ralph’s journey.

Now don’t get me wrong, there is nothing wrong with the theory and it is clearly effective in practice. Personally though, I found that I didn’t connect with the story and what should have been a compelling biography read more like a group of case studies from a university text book.

This is a pity as one cannot deny that Ralph is clearly a dynamic leader and gifted businessman. Obstacles Welcome is not the book for me; however, I recommend it to all those entrepreneurs out there interested in business development and growth.

You can find out a little bit more about Ralph on the site created for this book: http://www.obstacleswelcome.com