If I sum 24 observations of visits_by_each_hour , it doesn’t match the first observation of visits_by_day. Even if I sum visits_by_each_hour for the whole week, it doesn’t match the sum of visits_by_day either. Any explanation?