Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Structure Plugin : Bug Fix% Count no good.

Hi, I am looking to write a custom formula which will actually present the number of bugs fixed to the number of bugs open.

I looked at https://wiki.almworks.com/display/structure040/Advanced+Formula+Configuration

 

and I am unable to find help to configure a formula that checks for the status of the issue.

I am trying something like this:
WITH total_bugs =
SUM{ IF(itemtype='bug'; 1) } :
WITH open_bugs =
SUM { IF(itemtype='bug'; 1) AND IF(status NOT in ('closed', 'done', 'resolved'))};
IF (total_bugs > 0;
SUM IF(total_bugs-open_bugs/ total_bugs);0)

any pointers will be very useful.

1 answer

1 accepted

0 votes
Answer accepted

Hi Mukund,

Structure's formula does not currently support IN statement, though we are planning to introduce lists and operations with them in one of the upcoming releases. Currently, you can use MATCH or SEARCH functions, so you can replace 

IF(status NOT in ('closed', 'done', 'resolved')

with

IF(SEARCH(status, "closed,done,resolved")

Note that it can fail if you have statuses for example "resolved" and "not resolved", as it will find resolved in both names, but in common use cases it should work fine.

Regards,
Egor Tasa

ALM Works

This worked! THank you very much!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you