Execute Summary Query

Back to Query
coll_monthly_trends

Monthly trends in collections performance

Select the ingestion cycle to run this summary query against
Query Details
Source Table:
evolved_records
Dimensions:
2
Metrics:
6
Status:
Active
Execution Information

Dimensions:

  • DATE_TRUNC('month', created_at)
  • coll_product_group

Metrics:

  • (*) → account_count
  • (coll_total_due) → total_due_amount
  • (raw_data.collected_amount) → collected_amount
  • (coll_recovery_rate) → avg_recovery_rate
  • (CASE WHEN coll_is_special_case THEN 1 END) → special_case_count
  • (coll_commission_base_amount) → commission_base_total
© SimSol Technologies and Services Private Limited