jql - Jira Query Language for Structure Board - Stack Overflow

I have to update capacity calculating formula for my team members for each quarter manually. Instead of

I have to update capacity calculating formula for my team members for each quarter manually. Instead of doing this manual work I want to assign some variables on top of my code. Thus I can only update variable on top of the code. But I could not do that.

WITH M1_username = "username1":
WITH M1_username = "username2":
WITH M1_username = "username3":
WITH M1_username = "username4":

WITH SPRINT1 = "*Sprint 23.1 (wk15-16)*":
WITH SPRINT2 = "*Sprint 23.2 (wk17-18)*":
WITH SPRINT3 = "*Sprint 23.3 (wk19-20)*":

WITH M1_capSP1 = 7:

WITH M1_username = "omerk":

WITH M1_name = "Omer":

WITH PerHigh = 1.1:
WITH PerLow  = 0.9:

................

if ( notes = "SPRINT1", concat(
                //Member1
        if(ceiling(number(sum{if(match(sprint,"SPRINT1") and assignee = "M1_username" ,storypoints)},0),1)>M1_capSP1*PerHigh,"{color:red}",
        if(ceiling(number(sum{if(match(sprint,"SPRINT1") and assignee = "M1_username" ,storypoints)},0),1)<M1_capSP1*PerLow,"{color:blue}","{color:34E536}")),
        M1_name,":",ceiling(number(sum{if(match(sprint,"SPRINT1") and assignee = "M1_username" ,storypoints)},0),1),"/", M1_capSP1," ----- ","{color}"
        
        ..............
        
concat("{color}")))

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1745101106a4611277.html

相关推荐

  • jql - Jira Query Language for Structure Board - Stack Overflow

    I have to update capacity calculating formula for my team members for each quarter manually. Instead of

    12小时前
    20

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信