implement timeline rollups for trend analysis