Step by step create trello burndown

First of all, thanks echobehind for the original idea about how to get the burndown chart with Trello API and Google apps API.
http://echobehind.wordpress.com/tag/burn-down-chart/

Here, I did some improvement about the spreadsheet google script so that user can save some of the manual works.

In this blog, you will find a simple step by step about how to generate the the burndown chart from Trello.

Basically, the following three tools will used to get all things done:

  1. Scrum for Trello plug-in: A chrome plug-in used to assign points for the cards in Trello board
  2. Trello API: Use it to grab data from Trello board
  3. Google spreadsheet and Google Apps Script API: Calculate the data from trello board and show it in the table and burn-downs chart

The final sprint burn-downs chart will look like following:

NOTES: The Trello board and the google spreadsheet have the required field and settings to get things work properly.

Step 1. Install Scrum for Trello plugin and assign points for the ticket in trello board

Scrum for Trello is the Google Chrome plug-in, a tool to help you assign points for the ticket in trello board.

  1. Install “Scrum for Trello” for Google chrome from here.
  2. Open your trello board
  3. Click one of the ticket to edit it.
  4. On the popup, click the ticket title
  5. Assign points to the ticket

After assign points, the story point will show in the card as following image:

Step 2. Request trello application key and token

You need generate Trello application key to be allowed to call the Trello API. The Trello token from account is required when you need access the private board of the user. For the public data, don’t need token.

  1. Generate application key: Login Trello and access https://trello.com/1/appKey/generate
  2. You can request a token from a user by directing them to an authorization URL: https://trello.com/1/authorize?key=substitutewithyourapplicationkey&name=JuanApplication&expiration=never&response_type=token
    1. If the user accepts your request, they’ll be directed to a page where they will be given a token.
    2. This token will grant you will the read only access to this user’s private data, and unexpired

Later on, you need provide the application key and token to the spreadsheet script so that it can used to grab the Trello data with Trello API.

Step 3. Copy sprint burn-down spreadsheet from template

  1. Login google docs
  2. Open the google spreadsheet template: https://docs.google.com/spreadsheet/ccc?key=0AtdeTh2w78jgdElFbUkweUV2LTlJNUdlYWhTY1B3RHc#gid=5
  3. Use File -> Make a copy to generate your own spreadsheet from this template

After doing that, you will get the basic spreadsheet sheets and the script contains in the spreadsheet.

Step 4. Fill settings to get burn-down chart

Run script

  1. Open the google spreadsheet you generated in step 3
  2. Change the configurations in the “#settings” sheet, refer to section Settings to details about each configuration.
  3. Change the sheet name of the active sprint as something like “Sprint #active”
  4. Change the sprint information in the active sprint as you need, refer to section Sprint information for details.
  5. Then, go on to run script to grab the data from Trello: Tools -> Script Manager -> sprintStart
  6. It will help you fill all the column headers
  7. Within 5 minutes, the data of the current day will be grabbed from Trello board and filled in the spreadsheet.

The active sprint sheet will look like following:

Get Sprint burn-downs Chart

  1. Go to “Active Sprint Burndown Chart” sheet to edit the chart to point to the data to “Sprint #active” sheet

Now, you will get the burn-downs chart for the active sprint.

Preconditions

The Trello board and the google spreadsheet have the required field and settings to get things work properly

On Trello board

  1. Give points to the story
  2. Have a list named “DONE” to put all of the cards which have finished
  3. Have a label named “Unplanned” to label all of the cards which is not in the original plan

“#settings” sheet

The spreadsheet must contain a sheet named “#settings”, the google app script will get all of the global settings from here. The position of rows and columns can’t be changed.

  1. The first line: the guide site of how to use the template
  2. Trello Application Key: key to be allowed to call the Trello API
  3. Trello Token: required when you need access the private board of the user
  4. Sprint Info Column Index: The column index to store the sprint information in the active sprint sheet

Sprint information in each sprint sheet

In each sprint sheet, there should be two columns to give the sprint information. The google app script will get the sprint information from here. The order of the rows and columns shouldn’t be changed.

  1. Sprint #
  2. Sprint Name
  3. Start date: in format like, d.m.yyyy, such as: 24.8.2012
  4. End date: in format like, d.m.yyyy, such as: 24.8.2012
  5. Trello Board ID: The ID of the Trello board you want to grab the date from
  6. Extra None working days: the extra none working days except Saturday and Sunday. Use comma to separate multiple dates, such as: 24.8.2012,25.8.2012
  7. Extra working days: if there is any Saturday and Sunday will move to be a working day. Use comma to separate multiple dates, such as: 24.8.2012,25.8.2012

Miscellaneous

What is startSprint doing?

  1. Fill all the column headers in the active sprint sheet, including calculate the working day during the sprint
  2. Trigger “fetchData” to run every 5 minutes
  3. Trigger “endSprint” to run if the sprint reach the end date

About working days during the sprint

  1. By default, Monday to Friday will be working days, Saturday and Sunday will be treated as none working day
  2. If the working days appears in “Extra none working days”, it will be treated as none working day
  3. For all the none working days got from the last two steps, if it appears in “Extra working days”, it will be treated as working day
Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: