2 Replies Latest reply on Jun 6, 2016 1:58 PM by Tyler Pickering

    Mileage Bands

    Zachary Green

      I have a data set that shows shipments moving from point a to point b (OD pair) and all the detail that comes with it - weight, cost,miles,volume,etc.

       

      What I am wanting to do is create a mileage band that will show, in a text table, all the moves between 0-250 miles and what their avg CPM is. I am needing to do this for the miles buckets of 0-250, 250-500,500-750 and so on.

       

      Thank you in advance for your help