/
Progress calculation for the threshold

Progress calculation for the threshold

👉Try prototype here

🔢 Last Value Method

Takes the most recent period's performance and returns 100% if target was met, 0% if not

Best for current performance

  • Real-time dashboards

  • Current month focus

  • Immediate feedback

How it works:

  1. Take the last added value from the most recent period

  2. Compare it against the threshold for that period

  3. If condition is met → Progress = 100%

  4. If condition is not met → Progress = 0%

Current Calculation:

Last period: Dec - Value: 95, Threshold: 100

Result: ❌ Target not met→ Progress = 0%

🪫 Minimum of All Periods Method

Best for quality assurance

  • • Quality standards

  • • Risk management

  • • Compliance tracking

  • • "Weakest link" analysis

Finds the worst performing period and returns 100% if it met conditions, 0% if not

How it works:

  1. Find the period with the lowest performance ratio (value/threshold)

  2. Check if this worst period met its conditions

  3. If worst period met conditions → Progress = 100%

  4. If worst period failed → Progress = 0%

Current Calculation:

Worst performing period: Sep - Value: 88, Threshold: 100(Ratio: 88%)

Result: ❌ Worst period failed→ Progress = 0%

➗ Average of All Periods Method

Best for overall performance

  • Annual reviews (e.g. how ofter customer support miss/hit monthly KPI)

  • Trend analysis

Calculates the percentage of periods that met their conditions

How it works:

  1. Count periods that met conditions (each counts as 100%)

  2. Count periods that failed conditions (each counts as 0%)

  3. Calculate: (Successful periods × 100%) ÷ Total periods

  4. Result is the overall progress percentage

Current Calculation:

Successful periods: 7 × 100% = 700%

Failed periods: 5 × 0% = 0%

Total calculation: (700% + 0%) ÷ 12 periods

Result: Progress = 58.33%