fixed data aggregation for reports page