This discussion is archived
4 Replies Latest reply: Apr 21, 2013 10:35 AM by SashankPappu RSS

Grouping in BarGraphs

SashankPappu Newbie
Currently Being Moderated
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
    SashankPappu Newbie
    Currently Being Moderated
    Hi ,


    Could any please help me on this .

    Thank you,
    Sashank P.
  • 2. Re: Grouping in BarGraphs
    prateekazam Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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
    SashankPappu Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points