Hi.. I am to trying to create a structure board in jira using JQL query with columns as below

[Mano Solomon]

Dears,

Hi.. I am new comer to jira,  I tired to create a structure board in jira using JQL query with columns as below.

Request anyone to help me on below.(i need this to be created for  multiple projects)

1. Planned Story points
2. Completed Story points
3. SLA (completed Story points/Planned Story points.

Thanks,

Mano

[Egor Tasa [ALM Works] · Accepted solution]

Hi Mano,

What you require should be easy to do in Structure for Server/DC, but if you are using Cloud version, for now, there is no simple way to do that.

So, for Server you can create formula columns

1. SUM{IF(status!="Closed"; storypoints)}
2. SUM{IF(status="Closed"; storypoints)}
3. SUM{IF(status="Closed"; storypoints)/SUM{IF(status!="Closed"; storypoints)}

You may be using difference criterion to detect completed tasks, but otherwise the above is how this can be done.

Regards,
Egor Tasa

ALM Works

[Mano Solomon]

Thanks Egor..

I am doubt that we have same formula for both Planned story points and Completed Story points?

Please correct me.

Thanks,

Mano

[Egor Tasa [ALM Works]]

Hi Mano,

They differ by the condition you would use to consider an issue completed (in my example by the symbol of negation only)

Regards,
Egor 

[Mano Solomon]

Thanks Egor.. I got it..

Now another issue SLA column the decimal points  are not arranged in proper way. i have like (1.22222 instead of 122.22%)

i tried to used SUM{IF(status="Closed"; storypoints)/SUM{IF(status!="Closed"; storypoints)} and DISPLAY_FORMAT.SetMaximum(3)

Its not working..

[Egor Tasa [ALM Works]]

Hi Mano,

You'd have to use

ROUND(SUM{IF(status="Closed"; storypoints)/SUM{IF(status!="Closed"; storypoints)}*100;2)

Regards,

Egor

[Mano Solomon]

Thanks Egor its working fine.

i find some discrepancies in Total issue count for Active Sprint & Closed Sprint.

For active sprint is use :

IF (itemtype = 'issue';COUNT#ALL{Summary} and issueType !="Epic,Story,Spike,BUG")

For Closed Story points:

Sum{IF(Status = "Closed", Storypoints))

Thanks,

Mano