{% extends "core/base.html" %}{% load cohortly %}
{% block title %}MRR bridge{% endblock %}
{% block content %}
<div class="head"><h1>MRR bridge <small>{{ currency }}</small></h1>
<div class="actions"><a class="btn" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}format=csv">Export CSV</a></div></div>
<p class="muted">Opening + new + reactivation + expansion + contraction + churn = closing, verified for every month. Click an amount to list the customers behind it.</p>
<section class="card"><div class="scroll"><table>
<thead><tr><th>Month</th><th class="r">Opening</th><th class="r">New</th><th class="r">Reactivation</th><th class="r">Expansion</th><th class="r">Contraction</th><th class="r">Churn</th><th class="r">Closing</th><th class="r">Customers</th><th class="r">+New</th><th class="r">+React.</th><th class="r">-Churned</th></tr></thead>
<tbody>{% for r in rows %}{% with m=r.month|date:"Y-m" %}<tr>
<td>{{ m }}</td><td class="r">{{ r.opening|money }}</td>
<td class="r pos"><a href="{% url 'bridge_drill' m 'new' %}?{{ filter_qs }}">{{ r.new|money }}</a></td>
<td class="r pos"><a href="{% url 'bridge_drill' m 'reactivation' %}?{{ filter_qs }}">{{ r.reactivation|money }}</a></td>
<td class="r pos"><a href="{% url 'bridge_drill' m 'expansion' %}?{{ filter_qs }}">{{ r.expansion|money }}</a></td>
<td class="r neg"><a href="{% url 'bridge_drill' m 'contraction' %}?{{ filter_qs }}">{{ r.contraction|money }}</a></td>
<td class="r neg"><a href="{% url 'bridge_drill' m 'churn' %}?{{ filter_qs }}">{{ r.churn|money }}</a></td>
<td class="r"><b>{{ r.closing|money }}</b></td><td class="r">{{ r.closing_customers }}</td><td class="r">{{ r.new_customers }}</td><td class="r">{{ r.reactivated_customers }}</td><td class="r">{{ r.churned_customers }}</td></tr>{% endwith %}{% endfor %}</tbody></table></div></section>
{% endblock %}