preaggregation range added