Forum Discussion

cheid1977's avatar
cheid1977
Advocate I
9 years ago

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 refreshed with new data due to new shipment weights being added.  Is there a recommended formula that could be used that would allow the shipment weight to be grouped into these weight ranges i provided earlier and update as my data is refreshed? Thanks.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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"
      )

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi cheid1977,

     

    Have you tried the solution provided above? Does it work in your scenario? If the solution works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards

    • cheid1977's avatar
      cheid1977
      Advocate I
      9 years ago

      Thanks for the recommendation. I have had a chance to test it out. As soon as I do I will let you know if it works.