4 Replies Latest reply: Apr 21, 2013 12:35 PM by Sashank Pappu RSS

    Grouping in BarGraphs

    Sashank Pappu
      Hi ,

      I have a requirement where i need to group the x-axis according to the data. For Example , we have employees and departments and I wanted to display Sal and Comm in y-axis and Group all the employees of particular department in x-axis . Like employees 101,102,103 should be grouped with department 10. and employees with ids as 105,106,107 should be grouped to dept 20 . Could you please guide us on this.

      Thank you,
      Sashank P
        • 1. Re: Grouping in BarGraphs
          Sashank Pappu
          Hi ,


          Could any please help me on this .

          Thank you,
          Sashank P.
          • 2. Re: Grouping in BarGraphs
            prateekazam
            Hi ,

            Create the VO which qualify your requirement and while drag and drop select correct x-axis and bars.

            If still not please paste your page def code.

            Thanks
            Prateek
            • 3. Re: Grouping in BarGraphs
              prateekazam
              Hi ,

              Create the VO which qualify your requirement and while drag and drop select correct x-axis and bars.

              If still not please paste your page def code.

              Thanks
              Prateek
              • 4. Re: Grouping in BarGraphs
                Sashank Pappu
                Hi Prateek ,

                I tried most of the ways but it didnt help . Please find the below code of page def.

                <?xml version="1.0" encoding="UTF-8" ?>
                <pageDefinition xmlns="http://xmlns.oracle.com/adfm/uimodel"
                version="11.1.1.61.92" id="groupPageDef"
                Package="apps.com.grouping.view.pageDefs">
                <parameters/>
                <executables>
                <variableIterator id="variables"/>
                <iterator Binds="ViewObj1" RangeSize="-1" DataControl="AppModuleDataControl"
                id="ViewObj1Iterator"/>
                <iterator Binds="EMPDEPTVO1" RangeSize="-1"
                DataControl="AppModuleDataControl" id="EMPDEPTVO1Iterator"/>
                </executables>
                <bindings>
                <graph IterBinding="EMPDEPTVO1Iterator" id="EMPDEPTVO1"
                xmlns="http://xmlns.oracle.com/adfm/dvt" type="BAR_VERT_CLUST">
                <graphDataMap leafOnly="true">
                <series>
                <data>
                <item value="Salary"/>
                </data>
                </series>
                <groups>
                <item value="DepartmentId"/>
                <item value="EmployeeId"/>
                </groups>
                </graphDataMap>
                </graph>
                </bindings>
                </pageDefinition>


                Thank you,
                Sashank P.