Execute Summary Query

Select Cycle * -- Select a cycle -- Cycle #1 - 2025-11 Cycle #2 - 2025-11

Select the ingestion cycle to run this summary query against

Run asynchronously (recommended for large queries)

Force recalculation (ignore cached results)

---

Execute Query Preview SQL

Dimensions:

• coll_agency_code
• raw_data.agency_name

Metrics:

• (*) → total_accounts
• (CASE WHEN coll_agent_code != 'UNKNOWN' THEN 1 END) → has_agent_code
• (CASE WHEN coll_commission_base_amount > 0 THEN 1 END) → has_base_amount
• (CASE WHEN coll_negative_allowed = false AND coll_commission_base_amount < 0 THEN 1 END) → negative_blocked
• (coll_commission_base_amount) → total_commission_base
• (coll_emi_capping_amount) → avg_emi_capping
• (CASE WHEN coll_is_special_case THEN 1 END) → special_case_count