Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

Measuring Development Value Stream

Hi, I want to create a Value Stream Map for the development Value Stream of my team.

My plan is to create tasks for each step in the Value Stream, have each assignee log the time spent to perform each step (VA).

I would like JIRA to calculate the lead times based upon the status of the task (time from "in progress" to "done")

Has anyone ever done this before and is there a certain report I can use to get this information:

- Avg. Value Added Time per task

- Avg. Lead Time per task

I would also like to know if and how you measure the %C/A (% Correct and Accurate)?

1 comment

You can absolutely solve this using the Better Excel Exporter app and a custom report template which:

  1. Exports some basic information about the task (typically issue key, summary, assignee, etc.)
  2. Exports the time spent field (i.e. the time metric that you can use for further calculation)
  3. Implement a little script that offers a method with a signature like
    long getLeadTime(issue) 
    It finds the change of the "status" field from the old value "In progress" to the new value "Done" in the issue's field change history. Then it calculates the lead time by subtracting the timestamp of entering "In progress" from the timestamp of entering "Done".
  4. Now you have all metrics and you can apply Excel formulas and functions like AVG(), render these into charts, pivot tables, pivot charts in the template.

Having this, you can get the report by one click from any issue set at any time!

Tip: there is a workflow report template shipped with this app which could be a great starting point, as it works a dead-simple concept of "time metric".

(Disclaimer: it is paid and supported app, developed by my team.)

See: http://www.midori-global.com/products/better-excel-exporter-for-jira/template-gallery#workflow-reports

jira-workflow-report-pivot-chart

Comment

Log in or Sign up to comment
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you