How would I split a query's data into groups to analyse distribution ?
If my data was say integers from 1 to 100, I'd like to get
1-10 count = 6
11-20 count =3
21-30 count = 5
31-40 count = 2 etc
It would be really cool if there was a method to specify the number of groupings for the range of data values.
pseudo for above.. Group at d.Max / 10 (ten groupings)
Any thoughts ?