Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom coefficient calculation based on jira data

Ходырев Иван (Server)
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 20, 2018

I have a task to calculate custom coefficient for each person in my department. 
The formula is as follows:
coefficient=sum_estimates(person,month) / (work_time(person,month) - sum_worlog_times_in_task_x(person, month, taskId))

where 
sum_estimates(person,month) - sum of estimates of closed tasks for a particular person in a particular month

work_time(person,month) - working time for a person (actually this data should not be taken from jira and will be a constant when calculation occurred, but it have to be different for each person)

sum_worlog_times_in_task_x(person, month, taskId) - sum of work log times of a particular person to a task with a particular taskId in a particular month.


What is the best way to implement such calculation in Jira and probably to make some kind of report which calculates everything automatically?

1 answer

0 votes
Gezim Shehu [Communardo]
Community Champion
March 20, 2018

Depends on where would you like to display this.

Report only (get data from db or rest service), confluence(integration), jira itself (not sure how to best implement this)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events