Function generationTimeCountExprSql

apps/web/src/routers/usage-analytics-router.ts:410–418

(tier: GranularityTier)

    case 'outputInputRatio':
      return 'CASE WHEN COALESCE(SUM(total_input_tokens), 0) = 0 THEN 0 ELSE COALESCE(SUM(total_output_tokens), 0)::FLOAT / SUM(total_input_tokens)::FLOAT END';
  }
}

function generationTimeCountExprSql(tier: GranularityTier): string {
  if (tier === 'hourly') {
    return 'IFF(total_generation_time_ms IS NOT NULL, 1, 0)';
  }
  // Daily rollups do not currently carry a generation-time observation count.
  // Derive one only for the window backed by hourly rollups so older daily
  // history does not reuse latency_count as an incorrect denominator.
  return 'IFF(total_generation_time_ms IS NOT NULL AND usage_date >= DATEADD(day, -7, CURRENT_DATE), 1, 0)';
}