1 Reply Latest reply on Apr 13, 2017 9:51 AM by Sushmitha Reddy

    Bin creation does not take max value of the field automatically

    Samim Riaz

      Hi,

       

      I am creating a bin for a spend field. The bin is automatically filling in the min and max value but the max value is less than the actual max value for the field.

      Any idea why this is happening?

        • 1. Re: Bin creation does not take max value of the field automatically
          Sushmitha Reddy

          Hi Samim,

           

          In some cases( well, in most of the cases), the max value of the bin may not be equal to the max value of the measure.

          See the below example.. List of 20 orders with their price values ranging from $95 to $1.

          Screen Shot 2017-04-13 at 9.44.53 AM.png

           

          To create the bins of same size, it is determined that each bin should be of size 11.15.

          Screen Shot 2017-04-13 at 9.49.18 AM.png

          Hence, starting from the 0, it takes multiples of 11.15 till it reaches the maximum value. And the bin column represents the starting value of each bin.

          But it actually means..

          Screen Shot 2017-04-13 at 9.38.51 AM.png

           

          Hope this helps you understand why the last bin is less than the max(measure value).

          1 of 1 people found this helpful