Edit Summary Query

Back to List
Basic Information
Unique name used to reference this query
The primary table to query
Comma-separated tags for categorization
Dimensions & Metrics
Fields to group by (drag to reorder, order matters)
Table Joins
Filters
Advanced Options
Maximum number of results to return (optional)
Optional expression to apply to each result row after aggregation
Field Registry Integration
Auto-Sync Enabled

This summary query will automatically register its fields in the Field Registry upon saving:

  • Dimension fields will be registered as filterable and gridable
  • Metric fields will be registered as computable
  • All fields will be tracked with lifecycle management
  • Fields are never deleted, only deprecated when removed
Registered Fields

This query has registered the following fields:

Dimensions:
  • coll_settlement_analysis_coll_installment_type
  • coll_settlement_analysis_coll_bom_bck_club
Metrics:
  • coll_settlement_analysis_settlement_count
  • coll_settlement_analysis_total_due_amount
  • coll_settlement_analysis_settlement_amount
  • coll_settlement_analysis_avg_discount
  • coll_settlement_analysis_avg_settlement_percentage
  • coll_settlement_analysis_commission_base_total
© SimSol Technologies and Services Private Limited