coll_agent_weekly_trend

Edit Execute Back to List
Basic Information
Name:
coll_agent_weekly_trend
Description:
Weekly trend analysis by agent
Source Table:
evolved_records
Status:
Active
Visibility:
Public
Tags:
category_collections trend_analysis agent weekly
Query Configuration
Dimensions:
  • coll_agent_code
  • raw_data.week
  • raw_data.month
  • raw_data.year
Metrics:
  • * () → account_count
  • coll_total_due () → total_due_amount
  • raw_data.collected_amount () → collected_amount
  • coll_recovery_rate () → avg_recovery_rate
Filters:
  • summary_data.category_code = COLLECTIONS
  • coll_agent_code != UNKNOWN
  • raw_data.week IS NOT None
Order By:
  • coll_agent_code (ASC)
  • raw_data.year (ASC)
  • raw_data.month (ASC)
  • raw_data.week (ASC)
Recent Executions

No execution history available.

© SimSol Technologies and Services Private Limited