support having on global aggregations