Forum Discussion
Data Range Grouping
I would like to take shipment weights and break them down into weight ranges (ex. 0 - 5, 5 -10, 10-20, etc). I tried the Groups function, but I would have to update that everytime my data was refres...
I would just add a calculated column "Weight Bucket". There are a few ways to do this (eg, you could have a separate table that controls the buckets and lookup into it) or whatever, that has the formula (something like)
Bucket = SWITCH( TRUE(),
[Weight] <= 5, "0-5",
[Weight] <= 10, "5-10",
...
[Weight] <= 100, "80-100",
"Real Heavy"
)