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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

178 views 0 4
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