check overlapping data in aggregate, and keep non-nan values