Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to sort by RICE score in Product Discovery except for the sum or average for grouped ideas

Tiger Smith
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 21, 2023

In Product Discovery you can give ideas scores (e.g., RICE Score), and then sort by the score.  However, this blends all the ideas together.  I can group them by something (e.g. Epic) and then I can also see the sum or average of their scores grouping.  But how do I sort by descending by the group score sum or average?

 

See below:  each item within the group is sorted by the RICE score descending but the group containers themselves aren't.  

Screenshot 2023-07-21 at 2.41.45 PM.png

2 answers

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 22, 2023

Hi @Tiger Smith -- Welcome to the Atlassian Community!

That is not possible, and...

A cumbersome work-around would be to not group, but instead

  • add a field for the average score
  • calculate the new field with an automation rule (to roll up and average the values) when the source information changes for an idea (your RICE score and/or the Epic)
  • show the field in the view, and
  • add the new field as the first sort criteria, followed by your other sort criteria (the individual RICE score of the ideas)

Kind regards,
Bill

0 votes
Sayed Bares [ServiceRocket]
Community Champion
July 22, 2023

@Tiger Smith welcome to the community!

I think this is not possible at the moment. when you are sorting by a field it always sort the items under the group by elements. 

Tiger Smith
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 23, 2023

Thanks!  Can you manually change the order of those elements anyhow?

Sayed Bares [ServiceRocket]
Community Champion
July 24, 2023

@Tiger Smith I am afraid to say no, it is not even possible manually. Perhaps you can give @Bill Sheboy workaround a try. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events