aggregation analysis