OKR and KPI Tracking

def calculate_progress(
    baseline: float,
    target: float,
    current: float,
    direction: str = "increase",
) -> Dict[str, Any]:
    """
    Calculate progress % and status for OKR/KPI metrics.

    Args:
        baseline: Starting value.
        target: Target value.
        current: Current value.
        direction: "increase", "decrease", or "maintain".

    Returns:
        dict: {"progress": float, "status": str}
              progress = % toward goal(0–100+)
              status   = 🟢 (on track), 🟡 (at risk), 🔴 (off track)
    """

    if direction == "increase":
        progress = ((current - baseline) / (target - baseline)) * 100
    elif direction == "decrease":
        progress = ((baseline - current) / (baseline - target)) * 100
    elif direction == "maintain":
        "color: #6b7280;"># If maintaining, target is baseline — check if current is within ±5%
        tolerance = 0.05 * baseline
        if abs(current - baseline) <= tolerance:
            progress = 100
        else:
            progress = (1 - abs(current - baseline) / baseline) * 100
    else:
        raise ValueError("direction must be 'increase', 'decrease', or 'maintain'")

    "color: #6b7280;"># Bound progress
    progress = max(0, min(progress, 120))  "color: #6b7280;"># allow slight over-performance(up to 120%)

    "color: #6b7280;"># Status thresholds
    if progress >= 80:
        status = "🟢"
    elif progress >= 50:
        status = "🟡"
    else:
        status = "🔴"

    return {"progress": round(progress, 1), "status": status}

def get_all_metrics() -> List[Dict[str, Any]]:
    """
    Get all fields from the metrics table.

    Returns:
        list[dict]: List of fields.
    """
    if Api is None:
        raise RuntimeError(
            "pyairtable is not installed. Install it with `pip install pyairtable` "
            "to enable performance metrics data."
        )
    api = Api(AIRTABLE_API_KEY)
    table = api.table(AIRTABLE_BASE_ID, AIRTABLE_METRICS_TABLE_ID)
    records = table.all()
    return records

def update_metric(metric_id: str, data: Dict[str, Any]) -> None:
    """
    Update a field in the metrics table.

    Args:
        metric_id(str): The ID of the field to update.
        data(dict): The data to update the field with.
    """
    if Api is None:
        raise RuntimeError(
            "pyairtable is not installed. Install it with `pip install pyairtable` "
            "to enable performance metrics updates."
        )
    api = Api(AIRTABLE_API_KEY)
    table = api.table(AIRTABLE_BASE_ID, AIRTABLE_METRICS_TABLE_ID)
    table.update(metric_id, data)