nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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)

Planned Story points
Completed Story points
SLA (completed Story points/Planned Story points.

Thanks,

Mano

Accepted answers

Egor Tasa [ALM Works]

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

SUM{IF(status!="Closed"; storypoints)}
SUM{IF(status="Closed"; storypoints)}
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

All comments

Egor Tasa [ALM Works]

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

SUM{IF(status!="Closed"; storypoints)}
SUM{IF(status="Closed"; storypoints)}
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..

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud