wbTeamPro Feature Request & Bug Tracker
All Projects | wbTeamPro | wbTimeLog
Dashboard | Features | Bugs | | My View | View Issues | Change Log | Roadmap | My Account
  
wbTeamPro and wbTimeLog are actively being developed and supported.

We are working to update our tracker, changelogs, and documentation to convey this appropriately.
Thank you for your patience as we manage this period of growth.

View Issue Details [ Jump to Notes ] [ 
1 Vote
 ] 		[ Issue History ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0010255wbTeamPro[All Projects] Featurespublic2017-01-30 09:312015-01-25 00:00
Reporterwebuddha 
Assigned Towebuddha 
PrioritynormalSeverityminorReproducibilityalways
StatusImplementedResolutionadded 
PlatformOSOS Version
Product Version 
Target VersionApplied to Versionv3.0.14 
Summary0010255: Action Listing by Calculated Priority
DescriptionImprove the action list sorting to provide better priority sorting using a weight value, priority value, due date, and percentage completed.
Tagsaction, list view
Attached Files

- Relationships

-  Notes
(0010050)
webuddha (administrator)
2013-06-19 10:47
edited on: 2013-06-19 10:53

 This value could be called the "Score" representing something like this:

Score = (Date > Due Date ? (Date - Due Date) : exp(Due Date - Date)) * (Priority) * (Weight) * ((100 - Percentage Complete)/100)
(0010051)
webuddha (administrator)
2013-06-22 10:48
edited on: 2013-06-24 13:58

 The total score is a value from 0..100, calculated based on the following weights.

70% = DateScore
10% = ActivityScore
10% = PriorityScore
10% = CompleteScore

IF(`action`.`action_complete`=100
  ,0
  ,(
    ((IF( `action`.`date_finish` = CURDATE()
      , 0.25
      , IF(
        `action`.`date_finish` > CURDATE()
        , IF( (DATEDIFF(`action`.`date_finish`,CURDATE())>365), 0, 0.25 - ((DATEDIFF(`action`.`date_finish`,CURDATE())/365)*.25) )
        , IF( (DATEDIFF(CURDATE(),`action`.`date_finish`)>90), 1, 0.25 + ((DATEDIFF(CURDATE(),`action`.`date_finish`)/90)*.75) )
        )
      )) * 70)
    + ((IF(
      (DATEDIFF(NOW(),`action`.`date_activity`)>90)
      , 1
      , IF(
        `action`.`date_activity`='0000-00-00 00:00:00'
        , IF(
          (DATEDIFF(NOW(),`action`.`date_modified`)>90)
          , 1
          , (DATEDIFF(NOW(),`action`.`date_modified`)/90)
          )
        , (DATEDIFF(NOW(),`action`.`date_activity`)/90)
        )
      )) * 10)
    + ((((`action`.`action_priority` - 1) / 2)) * 10)
    + ((IF( `action`.`date_finish` <= CURDATE()
      , 1
      , IF( ((DATEDIFF(`action`.`date_finish`,CURDATE()) / (DATEDIFF(`action`.`date_finish`,`action`.`date_start`)+1)) > (100 - `action`.`action_complete`))
        , ( (100 - `action`.`action_complete`) / (DATEDIFF(`action`.`date_finish`,CURDATE()) / (DATEDIFF(`action`.`date_finish`,`action`.`date_start`)+1)) )
        , 0
        )
      )) * 10)
  )
) AS `calc_actionScore`

- Issue History
Date Modified Username Field Change
2013-06-19 10:41 webuddha New Issue
2013-06-19 10:41 webuddha
2013-06-19 10:41 webuddha Tag Attached: action
2013-06-19 10:41 webuddha Tag Attached: list view
2013-06-19 10:47 webuddha Note Added: 0010050
2013-06-19 10:53 webuddha Note Edited: 0010050 View Revisions
2013-06-22 10:48 webuddha Note Added: 0010051
2013-06-22 10:48 webuddha Assigned To => webuddha
2013-06-22 10:48 webuddha Status New => In Progress
2013-06-24 13:58 webuddha Note Edited: 0010051 View Revisions
2013-06-24 13:59 webuddha Status In Progress => Implemented
2013-06-24 13:59 webuddha Applied to Version => v3.0.14
2013-06-24 13:59 webuddha Resolution open => added

Dashboard | Features | Bugs | | My View | View Issues | Change Log | Roadmap | My Account
  

Copyright © 2000 - 2024 MantisBT Team
Powered by Mantis Bugtracker