2 Replies Latest reply on Nov 15, 2012 11:16 AM by james.gilchrist

    Binning Data into Two Bins: Values < 1 and Values >=1

    james.gilchrist

      I have a set of people with the following two data elements. A location (1 of 5 locations) and another value that ranges from about 0.8 to 1.4. Something like the following except about 100 per location each having a different "data point"

       

      EmployeeLocationData Point
      JimBoston0.95
      JoeLA0.92
      SallyNew York1.1
      BillyChicago0.8
      JoeyBoston1.2
      StanNew York0.89
      KevinRaleigh1.4

       

      I want to show a simple bar graph (one bar per location) with each bar representing the number of values below 1 and equal to or greater than one, as a percentage of the total. And colored by "below 1" and "equal to or greater than 1". So two colors per bar.

       

      I created this once but cannot reproduce with an updated set of values. Driving me nuts that I can't recreate!