Automatically log time spent on issue

Hello.

I need to solve this case:

I need to automatically calculate how many hours user spent to work with issue.

Wherein I need to:

  • Calculate time spent for all issue historical assignees
  • Calculate time spent for each issue status
  • exclude non-working horus and days (we work mon-fri from 09:00 to 18:00)
  • include extra working hours

Given:

  • JIRA onDemand
  • Jira Agile: Kanban
  • Jira misc workflow extensions
  • eazyBi reports
  • Workflow have 4 main steps: Analysis - Development - Testing - Documenting
  • We changing assignee: at first - analyst, then - developer, then - QA, etc.

So, I need to count time spent for each transition status for each transition assignee.

Now I try to solve my problem by this way:

EazyBI could count days in transition and transition assignee, so I could make report like this:

In this case day = 8h.

We could plus manually logged time spent for each issue.

But I don't know how to account for non-working days.

I think, that is the better way is using standard jira feature - time tracker and automatically logging time by Post Functions (workflow toolbox plugin).

But Workflow toolbox plugin not avaliable for onDemand Jira (thanks Fidel Castro Armario)

Do you have any?

Thank you.

2 answers

Hi,

JIRA Workflow Toolbox is currently not available for JIRA onDemand (Cloud). You must be using JIRA Server if you are working with it. Can you confirm that?

Regards,

Fidel Castro Armario

Thank you for your correction.

I checked, I have only Jira Misc Workflow Extensions.

Corrected text of the question.

In current version cloud (onDemand) eazyBI can't count hours in a way you need. There is workaround for this in JIRA server case. There are plans for future to do some custom calculations during data import to solve this type of problems.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

227 views 0 6
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you