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

How to calculate remaining work days - Time tracking Edited

Hello everybody,

I need your help to implement a time tracking function. Below the use case.

We use a Jira service desk project (CLOUD version) to track and manage the change requests that an external supplier analyzes and develop. The process is quite easy. 

  1. periodically, we buy from the supplier a bunch of, say, 30 paid working days which will be used by the supplier to work on our software (develop the change requests);
  2. the project's stakeholders create on the JIRA board a new issue which describes the CR's requirements; one issue = one CR;
  3. the CR is assigned to the supplier which estimates the required effort to develop it, say 3 days; the supplier uses the JIRA default field estimated effort (in hours), so he reports 24 (3*8); The CR is in status "Pending"
  4. our IT department evaluates the CR filled with the supplier's quotation; 
    1. if it's not okay, the IT rejects the CR; the CR is in status "Rejected"
    2. if it's okay, the IT approves the CR and authorizes the supplier to work on the CR; so the IT authorizes the supplier to consume 3 days (or 24 hours) from the initial 30 days bunch; as a consequence, the remaining amount of paid days will be 27; the CR is in status "Approved".
    3. in any case we know that a specific CR will potentially consume 3 days from the initial 30 days bunch.

We need a system which, starting form a determined amount of paid days (e.g. 30 days, it must be editable) , helps us to automatically calculate the remaining paid days for all the CRs opened on the JIRA board, both in status "Pending" and "Approved".

In other words, the system must inform and us that , after approving a CR with an etimated effort of 3 days, we have 27 paid days left. 

So far, we couldn’t find any solution.

Any solution, also involving the purchase/installation of external plugin, will be appreciated.

Many thanks

Giuseppe 

May you please help me?

Many thanks ,

Giuseppe

1 answer

Hi @Giuseppe Piersantelli 

 

I think the Issue Formula Gadget of our Great Gadgets for Jira Cloud app can solve this for you. 

Here is what you need to do:

1. Create a filter in Jira that returns the issues that are Approved. 

2. Add the Issue Formula gadget on a dashboard and configure it to use your filter

3. Then set Formula to Sum and at Calculation field choose the Jira field that stores the effort estimation (Original Estimate)

4. Then enter this at math transformation: 30 - (x/(3600*8))

It will sub-stract from 30 (representing your total capacity in days) the sum of total approved estimates. Jira stores the time estimates in seconds, so you have to divide x to (3600*8) in order to transform seconds in days (1 day = 8h).

GadgetSettings.jpg

 

5. Click save and you will have the remaining displayed on your dashboard.

Gadget.png

 

For Jira Server see Great Gadgets for Jira Server .

Danut.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Announcing Jira Service Management!

Hello there Cloud Community members! Today, we’re thrilled to announce Jira Service Management, the next generation of Jira Service Desk. Jira Service Management touts advancements in IT service ...

2,190 views 28 39
Read article

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