Execute Summary Query

coll_settlement_analysis

Detailed analysis of settlement cases

Select Cycle *

Select the ingestion cycle to run this summary query against

Run asynchronously (recommended for large queries)

Force recalculation (ignore cached results)

Query Details

Source Table:: evolved_records
Dimensions:: 2
Metrics:: 6
Status:: Active

Execution Information

Dimensions:

coll_installment_type
coll_bom_bck_club

Metrics:

(*) → settlement_count
(coll_total_due) → total_due_amount
(raw_data.settlement_amount) → settlement_amount
(coll_settlement_discount) → avg_discount
(coll_settlement_percentage) → avg_settlement_percentage
(coll_commission_base_amount) → commission_base_total

© SimSol Technologies and Services Private Limited