grant total for the daily collection query testing