Skip to content

Add project cycle stats to player stats history #366

@heyheyjp

Description

@heyheyjp

Depends on #365.
Forked from features/project-stats-model.

Currently persisting:

  • Aggregate Build Cycles (ECC)
  • Relative Contribution (RC)
  • Estimated Contribution Cycles (ECC)

Add the following:

  • Hours worked
  • Expected contribution
  • Expected contribution delta
  • Culture contribution score
  • Learning support score

Expected Contribution (Percentage)

ROUND([Personal Hours] / [Total Team Hours] * 100)

Expected Contribution Delta

Expected Contribution - Relative Contribution

Culture Contribution

Find all CULTURE_CONTRIB scores for this project for that player
Calculate the average score
Subtract 1
Convert to % (divide by 6)

Learning Support

Find all LEARNING_SUPPORT scores for this project for that player
Calculate the average score
Subtract 1
Convert to % (divide by 6)

In this example, this is all retro feedback for a single project:

Feedback Type Feedback from Feedback to Score
Culture Shereef SJ 5
Learning Shereef SJ 6
Culture Jeffrey SJ 6
Learning Jeffrey SJ 7

Culture Contribution for SJ = ((((5+6)/2) - 1 ) / 6) = 75%
Learning Contribution for SJ = ((((6+7)/2) - 1 ) / 6) = 91.666%

Let's round to zero decimals.

  1. Score doesn't need to be weighted by hours or "recentness" since it only covers 1 project.
  2. Scores are from 1 to 7 so shifting them to 0 to 6 gives us the whole range of 0 to 100%.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions