Jira Product Discovery - Ordering Groups in "All Ideas" view

[James Harris]

Is there a way to order groups in the "All Ideas" view. For instance, when grouping by a certain field (in this case by Epic) - is there a way to order the groups by the average Fx Score?

[Bill Sheboy]

Hi @James Harris -- Welcome to the Atlassian Community!

I do not believe there is a built-in way to do that; it would require having roll-up data about the grouping of ideas.  When "group" is used, the sort always occurs within the group.

A work-around could be to use the matrix view...

• create a field for the Group Average Score
• use an automation rule to set the Group Average Score when an idea is created or the group changes for an idea
• create a matrix view
• set one axis to your group field
• set the other to your Group Average Score

Kind regards,
Bill

[James Harris]

Hi Bill, thanks for your answer!

I'm not sure if I've understood you fully but when creating the matrix using "group" and "score" as the axis, the matrix lists the tasks within the group separately, it doesn't average their scores.

Just checking I've understood you:

- When you say "create a field for Group Average Score", do you mean a separate field to the score field I use for the individual tasks? (which is a custom formula that pulls from other scores)

- By automation rule, do you mean the "none/average/medium/sum" selector for the field against the group column?

Thanks,

James

[James Harris]

[Bill Sheboy]

When I noted this was a work-around, I meant it will order the ideas by the average, but you would still need to select each average value on the matrix/chart view to see them.

Another work-around would be to calculate the average and NOT group ideas in the list view...and instead sort by the average scoring only.

For either work-around approach...Yes, I meant to create new field to hold your average value.  And then use automation for Jira rules to calculate the value when appropriate.

One example rule would be:

• trigger: field updated for your selected group field
• action: lookup issues with JQL to gather the ideas with the same selected group field.  With this, you can now find the average score 
• branch: on the same JQL as above, as now we want to update the issues' average score
  • action: edit issue, to set the average score to {{lookupIssues.Fx Score.average|0}}

You would need a second rule, triggered on issue created, with the same steps.  If you delete ideas, I believe you would need one more rule to handle that case.

If you have not created automation rules before, please let me know and I can provide some getting-started references.