groupby to avoid unnecessary reporting