Assigning & Viewing Stack Rank Order of JPD Ideas

[Mike Wilk]

Hi Everyone,

I'm looking for advice on how to best create a stack rank view of JPD ideas. My only theory is to use a combination of a couple fields:

• 1 field to identify only the subset of items you want - like a timeframe and/or status
• another field w/ a numeric value - requiring manually entering the # for each idea so you could use the "Sort" to see the subset in the stack rank order

If anyone else has any ideas or suggestions, I'd love to hear them.

Thanks!

[Amina Bouabdallah]

Thanks for the extra info - then i would suggest the following options

1. create a select field, with options "High pri", "Next highest pri", etc and assign to ideas
2. create a rating field, that has 5 bubbles, then decide a convention for matching the number of filled bubbles with the right priority (1 bubble = lowest pri, 5 bubbles = highest pri)
3. a number field, with values "1", "2", ...

with option 1: it's very clear what the priority is, because in plain text

with option 2: you have the easy visual, plus color gradient that comes with the rating 

with option 3: you can do formulas on the priority (eg. priority x effort / impact)

Does that help?

[Amina Bouabdallah]

Hi there - thank you for your post! By stack rank, do you mean something similar to the row number in Excel? or some other computed priority score? 

This determines the answer!

[Mike Wilk]

Not exactly like a row number in Excel. We want to assign a numeric value. For example, imagine we have 10 JPD ideas, we want to add a number to each idea so we can see which one is number 1, 2, 3, etc. That way we can view all the ideas in order either ascending or descending.

The goal is to be able to rank a number of ideas selected for DEV in an upcoming quarter based on the priority like this:

1. Highest priority
2. Next highest
3. etc.

[Amanda Barber]

You could get to this with some sort of computed value potentially like - 

• RICE scoring, with fields for Reach, Impact, Confidence, and Effort to prioritize ideas based on a custom RICE formula

Alternatively, you could also just add a numeric field and update it based on your ranking and potentially use automation to update? 

[Mike Wilk]

Thanks @Amanda Barber - Yeah, I'm playing with a numeric field to see if that will do the trick. The problem is that we need them for each quarter, so eventually there will be a lot of fields that serve no real purpose other than historical reference.

It would be awesome if there were a Priority Rank field specifically for the purpose of ranking ideas, but I can create a custom one.

I just wanted to see if anyone had any other ideas on how to solve the problem without having to create a field for each quarter's rankings.

[duncan.crowell]

I have a similar situation (i think) where I need to display priorities by Quarter, the way I have solved for this for now is to have 2 fields. 

1. a DVF priority score (custom formula)

2. a Candidate Quarter field (Multi Select)

The Custom Formula determines the stacked priority but then I use the Candidate Quarter field to then filter the priorities by the specific quarter we are looking at.  I have a list view that shows current status, Target release date and DVF score filtered by the current quarter. It then populates a stack ranked list of features that are either in flight or in plan that we can then have a conversation around. 

I just maintain the Candidate Quarter field with new upcoming quarters and remove old quarters as they become irrelevant. 

Hopefully this resonates with what you were trying to achieve?