How to cross information between story point and jira tempo ?

[Patrick Valibus]

Hi,

I had like to track on a regular basis, the time tracked for a task in tempo and compare it with the story point of this same task.

How can i do that easily ?

[Ignacio Pulgar]

Hi @Patrick Valibus ,

The easiest way I can think of would consist of:

1. Run the following JQL query by using the advanced mode of the Issue Navigator:

"Story Points" > 0 AND Timespent > 0

2.  Save your query as a filter.

3. Set the columns to be shown in your filter with at least: Issue Key, Summary, Story Points, Timespent.

4. Export the returned issues to your favorite spreadsheet software and create a column with a formula that calculates timespent column divided by story points column. After that, use a function to show the average timespent per story point.

Hope it helps.