It's all about the answers!

Ask a question

Report Builder - Sort states by specific order


Sterling Ferguson-II (1.6k9283269) | asked Apr 25, 3:13 p.m.

7.0.2


Status:

New
Assigned
Working
Completed

All, of course using Sort does Alphabetical or Reverse. How can I use Report Builder to display the status by the order above, or if I add additional states?

thanks


Comments
Fariz Saracevic commented Apr 25, 5:03 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

Hi Sterling,


You should be able to use custom expression to achieve what you are looking for.

One answer



permanent link
Pranjan Patel (211) | answered Apr 30, 1:06 a.m.
edited Apr 30, 3:27 a.m. by Fariz Saracevic (919613)

Hi Sterling,


You can get that report by using Custom Expression. So, This method can be implemented by adding the code below to a custom expression.

IF($Work Item:Status$ = "New", 1,

        IF($Work Item:Status$ = "In Progress", 2,

        IF($Work Item:Status$ = "Resolved", 3,

               IF($Work Item:Status$ = "Done", 4,5)

)))


This will add a new column which will allow you to sort based on the number which are related to the status.


Thanks,

Pranjan Patel

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.