How to calculate remaining work days - Time tracking

[Giuseppe Piersantelli]

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

[Danut M _StonikByte_]

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).

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

For Jira Server see Great Gadgets for Jira Server .

Danut.