{% extends "cpq/base.html" %}{% load cpq_extras %}{% block title %}Analytics{% endblock %}
{% block content %}
<h1>Analytics</h1>
<div class="stats"><div class="stat"><b>{{ d.cycle_time.average_days }} d</b><span>Avg quote cycle</span></div><div class="stat"><b>{{ d.cycle_time.median_days }} d</b><span>Median cycle</span></div>
<div class="stat"><b>${{ d.leakage.total_usd|floatformat:0 }}</b><span>Margin leakage (USD)</span></div><div class="stat"><b>{{ d.guardrail|floatformat:0 }}%</b><span>Auto-approve guardrail</span></div></div>
<div class="grid2">
<section class="card"><h2>Win rate by segment</h2>{{ c_segment }}</section>
<section class="card"><h2>Discount vs win probability</h2>{{ c_curve }}<p class="muted small">Closed quotes bucketed by overall discount (%); label n is the sample size.</p></section>
<section class="card"><h2>Average discount by rep</h2>{{ c_rep }}</section>
<section class="card"><h2>Average discount by product family</h2>{{ c_family }}</section>
<section class="card"><h2>Most discounted SKUs</h2>{{ c_product }}</section>
<section class="card"><h2>Cycle time by outcome</h2>{{ c_cycle }}</section>
</div>
<section class="card"><h2>Margin leakage report</h2><p class="muted small">Accepted quotes discounted beyond the {{ d.guardrail|floatformat:0 }}% guardrail, approved by exception. Leakage = list value × excess discount.</p>
<table class="tbl"><thead><tr><th>Quote</th><th>Rep</th><th class="r">Excess discount</th><th class="r">Leakage (USD)</th></tr></thead><tbody>
{% for i in d.leakage.items|slice:":15" %}<tr><td>{{ i.number }}</td><td>{{ i.rep }}</td><td class="r">{{ i.excess_pct }} pts</td><td class="r">${{ i.leakage_usd|floatformat:0 }}</td></tr>{% empty %}<tr><td colspan="4" class="muted">No leakage.</td></tr>{% endfor %}</tbody></table>
<p class="muted small">{{ d.leakage.count }} quotes in total. JSON: <a href="{% url 'api_analytics' %}">/api/analytics/</a></p></section>
{% endblock %}