Conditional KPI

How can we calculate the percentage of active employees?

Advanced⏱ 3 Minutes⭐ 1290 XP

🤔 THE QUESTION

How can we calculate the percentage of active employees?

💡 WHAT IS IT?

Dividing conditional aggregate sums by total COUNT(*) calculates percentage shares and conversion rates.

🎯 WHAT IS IT USED FOR?

Active user ratios, SLA compliance percentages, conversion and retention rates.

💻 EXAMPLE

SELECT
100.0 * SUM(
    CASE WHEN status = 'Active' THEN 1 ELSE 0 END
) / COUNT(*) AS active_percentage
FROM employees;

Practice typing production-grade SQL code for Conditional KPI.