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_product_group
• coll_aging_bucket

Metrics:

• (*) → total_accounts
• (CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.fixed') = TRUE THEN 1 END) → fixed_eligible
• (CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.additional') = TRUE THEN 1 END) → additional_eligible
• (CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.settlement') = TRUE THEN 1 END) → settlement_eligible
• (CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.deduction') = TRUE THEN 1 END) → deduction_eligible
• (coll_emi_capping_amount) → total_emi_capping
• (coll_emi_capping_amount) → avg_emi_capping