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
评论列表(0条)