Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Project Report - Weighted Ranking Query

Avatar

Level 1

I am creating a project report listing current projects.  I am having trouble creating a query which lists the weighted ranking based of the data displayed in the 'Priority' and 'Benefit & Effort Score' columns.

The Priority allowed values are High, Medium, and Low. The Benefit & Effort Score value range from 1.0 to 10.0.

 

The expected report data for the Weighted Ranking allows users to see the Top 10 projects based on a combined high Priority and Highest Benefit & Effort score etc. 

I am not sure of next steps to complete this query.

displayname=Weighted Ranking
textmode=true
valueexpression=IF({priority}="Medium","5")
valueformat=HTML

 

Thank you!

 

 

 

 

 

1 Reply

Avatar

Community Advisor

I wonder if you can make this easier on yourself without text mode while achieving the same result. Perhaps utilize filters more to pull only projects with certain priorities AND scores, and that filter combination essentially gives these projects weight. For example with just 1 score example, of course you can replace with any score-related filters:

Madalyn_Destafney_0-1711395759918.png

Once you filter these in, you could sort the report columns by the next level down you want to see, like project planned completion date, for example. Thoughts?

If this helped you, please mark correct to help others : )