Project Report - Weighted Ranking Query | Community
Skip to main content
M
MarySt4
New Participant
March 25, 2024
Solved

Project Report - Weighted Ranking Query

  • March 25, 2024
  • 1 reply
  • 626 views

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!

 

 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Madalyn_Destafney

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:

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?

1 reply

Madalyn_Destafney
Madalyn_DestafneyAccepted solution
New Participant
March 25, 2024

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:

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 : )
    M
    MarySt4Author
    New Participant
    May 6, 2024

    Thank you so much Madalyn for the recommendation.  It was really helpful!

      Terms & ConditionsAccessibility statement

      Loading footer...