gathering data for last six months