14 Replies Latest reply: Jul 31, 2015 5:22 AM by kushal chawda RSS

    Location wise Avg

      Hi All,

       

      Avg Per day per Person should be bucketed

       

      Data :-

       

      DateLocationNameHandled
      7/1/2015BlrRaj 11500
      7/1/2015ChnRaj 21000
      7/1/2015TJRaj 3600
      7/1/2015ChnRaj 41000
      7/3/2015TJRaj 31000
      7/3/2015BlrRaj 1900
      7/6/2015ChnRaj 2500
      7/6/2015BlrRaj 5

      1000

       

      Avg Per person Per day to be bucketed as given below.

       

       

      LocationRow LabelsAverage of HandledBucket
      BlrRaj 112001000 - 1500
      ChnRaj 2750500 - 1000
      TJRaj 3800500 - 1000
      ChnRaj 410001000 - 1500
      BlrRaj 510001000 - 1500

       

       

      Final Output:

       

      Location0 - 500500 - 10001000 - 1500> 1500
      Blr2
      Chn11
      TJ1