hours analytic as aggregation in API