2 Replies Latest reply: Aug 14, 2013 6:52 PM by user10615659 RSS

    Create Buckets in OBIA report

    970462


      Hi Everyone!!

       

      I am basicaaly new to OBIA Reports. I dont know if I am asking a basic question or not but I have a requirement to create a  report where I have to create buckets for a particular column.

      I have researched online and figured out that it can be done in several ways in RPD or in the report.

      I didnt find any document or any link which shows how to do exactly.

      It can be done by creating bins in edit formula for the respective column.

       

      My question is for creating buckets do we have to create bins and hide them .Can anybody please let me know is this the correct

      way to create buckets or is there any other way to do it.

       

      If anyone can share me any documents or links would be really helpful.

       

      Any suggestion would be really appreciated

       

      Thanks in Advance!!!

        • 1. Re: Create Buckets in OBIA report
          Sasi  Nagireddy

          What is " have to create buckets for a particular column " ? Could you be bit clear ?


          Thanks,

          • 2. Re: Create Buckets in OBIA report
            user10615659

            Let me say you have a Percentage metrics.

            you want to bucket it as A,B,C,D such that

            <25  - A

            25<B<50

            50<C<75

            D>75.

             

            you need to make use of the metrics Percentage column and click Edit formula and use switchcase in expression and write something like

            Case

            when Percentage <25 then 'A'

            when 25<Percentage <50 then 'B'

            when 50<Percentage <75 then 'C'

            else D end

             

            this will bucket the percentage values in A,B,C & D.

            hope this helps. this you can do it in reports and rpd as well.

             

            regards,

            Senthil