Perhaps, I’m overthinking this, but I can’t seem to figure out how to take a list of decimals and group it into data ranges and get a count for each range. Ideally, I would want the minimum value to always be zero regardless of the selected data, and the max should be the max value of the data set. Then I should be able to provide a divisor which would define how many groups I want the data to be divided into. I would prefer not to use a temp table is possible
sample set:
150.75
250.01
600.10
900.50
The output with a divisor of 2 would be:
| RangeStart | RangeEnd | Count |
| ---------- | -------- | ----- |
| 0 | 450.25 | 2 |
| 450.26 | 1000 | 2 |