tests corrected with the recent change of adding date to the aggregation query