Book of Data Recipes

Assigned User Trends

Questions Being Answered: How much work is each team member taking on over the course of time? Who keeps taking on all of the work?

Data set required: Historical User Assignments

Fields to include:

• Assigned to Date
• Assigned User Full Name
• Duration (Days)

Additional Interesting Details:

• Priority field to understand who is working on the most critical items
• Card Type Title to understand variety of work being taken on
• Card Title to get more details
• Card Size sum to see how points add up across all cards (add Cards data source and join data by Card ID)

Blocked WIP

Question Being Answered: What work in process is currently blocked?

Data sets required: Cards

Fields to include:

• Last Activity Date
• Current Board ID
• Card ID
• Card Title
• Current Blocked Reason
• Actual Start Date
• Actual Finish Date

Filter Criteria:

• Current Blocked Reason = not null
• Actual Start Date = not null
• Actual Finish Date = null

Additional Interesting Details:

• Include Priority to understand risk level associated with blocker
• Include and/or sort by Parent Card Title to see what higher level efforts are impacted

Blocker Trends

Questions Being Answered: How often have we blocked work? Is that number increasing or decreasing over time?

Data sets required: Cards

Fields to include:

• Last Activity Date
• Current Blocked Reason
• Board Title

Filter Criteria:

• Board Title
• Is Card Blocked = not null

Additional Interesting Details:

• Include Tag information for additional filtering (add Tags data source and join data by Card ID)

Project Progress

Question Being Answered: What is the overall status of our initiatives?

Data set(s) required: Cards

Fields to include:

• Parent Card Title
• Card Size
• Current Lane

Logic: Sum of card size per lane by parent card title

Additional Interesting Details:

• Actual start and actual finish date logic to determine progress if lane structure is complex
• Card Type filtering
• Priority to evaluate risk

back to top 

Estimated vs. Actual Hours

Question Being Answered: What were the actual hours compared to estimated hours?

Data set(s) required: Cards, Custom Fields (join with Card ID)

Fields to include:

• Card Title
• Card Size
• Custom Field used for hours tracking

Logic: Calculate difference between estimated hours to actual hours to arrive at over/under.

Additional Interesting Details:

• Priority to evaluate impact
• Include Parent Card ID to group/sort by “Project/Epic/Story”
• Include Card Type for grouping

(Example uses Card Size as “estimated” and Custom Field as “actual” where some customers may use Custom Field for both estimate and actual)

Planned Start and Finish View

Questions Being Answered: When is work scheduled to begin and end? Where is there overlap?

Data set(s) required: Cards

Fields to include:

• Planned Start
• Planned Finish
• Card Title

Logic: Calculate difference between Planned Start and Planned Finish to arrive at planned duration. Show planned start and duration to create gantt view.  

Additional Interesting Details:

• Include Card is Blocked field to show where work is being held up
• Filter by Card Type
• Blend with Tags data set (join via Card ID) to filter results by tag
• Blend with Current User Assignments (join via Card ID) to see assignee information