267 total views, 1 views today

ADF DVT: Create a simple Bar Chart from table

ADF Data Visualization components provide user to display data in graphical representation like Chart, Map, Gauze, Pivot table, Gantt Chart, etc. This section we walk through about  creating a Bar chart from a database table (Job table in HR Schema) . As shown in the below image, left side is ‘Job’ table data which has JobTitle, MinSalary, MaxSalary  fields and Right side is the Bar Chart representation of the same data, X-Axis contains the Job-Title and Y-Axis contains  MinSalary and MaxSalary.  

121216_0038_ADFDVTCreat1 ADF DVT: Create a simple Bar Chart from table


 

ADF Bar Chart:- Example Started

 

1. Create an ADF Fusion WebApplication (File, New, Gallery, Application, ADF Fusion Web Application)

121216_0038_ADFDVTCreat2 ADF DVT: Create a simple Bar Chart from table

 

2. Create a View Object from Jobs table (Instruction: how to create Entity and View Object )

 

3. Create a JSF page by right click on the ViewController >> New >> Page >> Input a name index.jsf and click Ok

121216_0038_ADFDVTCreat3 ADF DVT: Create a simple Bar Chart from table

 

4. Expand Data Controls >> Drop ‘JobEOView’ object inside the <Form> tag of the JSF page and Select Chart from the menu

121216_0038_ADFDVTCreat4 ADF DVT: Create a simple Bar Chart from table

 

5. Select a Chart and Click Ok

121216_0038_ADFDVTCreat5 ADF DVT: Create a simple Bar Chart from table

 

 

6. Drag and Drop (MaxSalary & MinSalary to YAxis) and Drop (JobTitle to XAxis)

121216_0038_ADFDVTCreat6 ADF DVT: Create a simple Bar Chart from table

 

 

7. Click Ok

121216_0038_ADFDVTCreat7 ADF DVT: Create a simple Bar Chart from table

 

 

8. Right click on the index.JSF page >> Click Run. The Bar chart will get displayed on the browser with salary on the Y-Axis and Job-Title on X-Axis 

121216_0038_ADFDVTCreat8 ADF DVT: Create a simple Bar Chart from table

govindan ADF DVT: Create a simple Bar Chart from table
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan ADF DVT: Create a simple Bar Chart from table
Connect me
By | 2016-12-11T20:33:05+00:00 December 11th, 2016|Categories: ADF|Tags: , , |0 Comments
Like us on Facebook.
Connect!