How do you group by Day

[pneuvil1]

Grouping by Created gives you ranges. I need to average things on a per day basis. I've not seen anything in the wiki.

[ghsrikanth]

You could get this stats in reporting module.

Like number of incidents created for each day and many more, stats per day.

[pneuvil1]

Actually, you can't do that. when you group by created in a report, it creates ranges. Buckets where your results go in. Example 2 days, 2-5 days, 5-7 days, etc...

I need to computer an aggregate for each day.

[pneuvil1 · Accepted solution]

actually it is accomplished not by group by, but rather creating a trend report that trends by a date field, then selecting Per: Date...