coll_monthly_trends

Edit Execute Back to List
Basic Information
Name:
coll_monthly_trends
Description:
Monthly trends in collections performance
Source Table:
evolved_records
Status:
Active
Visibility:
Public
Tags:
category_collections monthly_trends
Query Configuration
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
Filters:
  • summary_data.category_code = COLLECTIONS
  • created_at >= CURRENT_DATE - INTERVAL '12 months'
Recent Executions

No execution history available.

© SimSol Technologies and Services Private Limited