Aggregation and grouping with dates and integers
I was able to accomplish by setting my aggregation differently. I set it to sum and with value checked it began to work as documented. thanks. Let  me know if anyone is having trouble with aggregation its kinda tricky getting to function properly thanks!