Developing Dashboard Graphs

Complete Oracle ADF 12c Course for Beginners Create a Complete ADF Application
10 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€65.24
List Price:  €93.21
You save:  €27.96
£55.79
List Price:  £79.71
You save:  £23.91
CA$95.78
List Price:  CA$136.84
You save:  CA$41.05
A$107.15
List Price:  A$153.08
You save:  A$45.92
S$95.25
List Price:  S$136.08
You save:  S$40.82
HK$547.16
List Price:  HK$781.69
You save:  HK$234.53
CHF 63.78
List Price:  CHF 91.12
You save:  CHF 27.33
NOK kr771.03
List Price:  NOK kr1,101.52
You save:  NOK kr330.49
DKK kr486.66
List Price:  DKK kr695.26
You save:  DKK kr208.59
NZ$117.65
List Price:  NZ$168.07
You save:  NZ$50.42
د.إ257.05
List Price:  د.إ367.24
You save:  د.إ110.18
৳7,682.75
List Price:  ৳10,975.83
You save:  ৳3,293.07
₹5,839.27
List Price:  ₹8,342.17
You save:  ₹2,502.90
RM334.02
List Price:  RM477.20
You save:  RM143.17
₦92,745.84
List Price:  ₦132,499.74
You save:  ₦39,753.90
₨19,488.62
List Price:  ₨27,842.08
You save:  ₨8,353.45
฿2,593.98
List Price:  ฿3,705.84
You save:  ฿1,111.86
₺2,266.58
List Price:  ₺3,238.11
You save:  ₺971.53
B$358.23
List Price:  B$511.78
You save:  B$153.55
R1,308.04
List Price:  R1,868.72
You save:  R560.67
Лв127.69
List Price:  Лв182.42
You save:  Лв54.73
₩96,593.58
List Price:  ₩137,996.75
You save:  ₩41,403.16
₪262.11
List Price:  ₪374.46
You save:  ₪112.34
₱4,037.82
List Price:  ₱5,768.57
You save:  ₱1,730.74
¥10,982.62
List Price:  ¥15,690.13
You save:  ¥4,707.51
MX$1,188.90
List Price:  MX$1,698.50
You save:  MX$509.60
QR255.36
List Price:  QR364.82
You save:  QR109.45
P960.21
List Price:  P1,371.80
You save:  P411.58
KSh9,275.87
List Price:  KSh13,251.81
You save:  KSh3,975.94
E£3,354.25
List Price:  E£4,792
You save:  E£1,437.74
ብር4,018.25
List Price:  ብር5,740.61
You save:  ብር1,722.35
Kz58,443.04
List Price:  Kz83,493.64
You save:  Kz25,050.60
CLP$66,028.30
List Price:  CLP$94,330.18
You save:  CLP$28,301.88
CN¥506.69
List Price:  CN¥723.88
You save:  CN¥217.18
RD$4,095.54
List Price:  RD$5,851.02
You save:  RD$1,755.48
DA9,393.81
List Price:  DA13,420.31
You save:  DA4,026.49
FJ$158.42
List Price:  FJ$226.32
You save:  FJ$67.90
Q544.03
List Price:  Q777.22
You save:  Q233.19
GY$14,645.70
List Price:  GY$20,923.32
You save:  GY$6,277.62
ISK kr9,806.99
List Price:  ISK kr14,010.59
You save:  ISK kr4,203.60
DH708.51
List Price:  DH1,012.20
You save:  DH303.69
L1,235.26
List Price:  L1,764.74
You save:  L529.47
ден4,024.43
List Price:  ден5,749.43
You save:  ден1,725
MOP$564.37
List Price:  MOP$806.28
You save:  MOP$241.91
N$1,312.44
List Price:  N$1,875
You save:  N$562.55
C$2,589.99
List Price:  C$3,700.15
You save:  C$1,110.15
रु9,350.18
List Price:  रु13,357.97
You save:  रु4,007.79
S/262
List Price:  S/374.30
You save:  S/112.30
K266.57
List Price:  K380.83
You save:  K114.26
SAR262.49
List Price:  SAR375.01
You save:  SAR112.51
ZK1,865.62
List Price:  ZK2,665.29
You save:  ZK799.66
L324.62
List Price:  L463.77
You save:  L139.14
Kč1,642.25
List Price:  Kč2,346.17
You save:  Kč703.92
Ft25,489.50
List Price:  Ft36,415.13
You save:  Ft10,925.63
SEK kr767.15
List Price:  SEK kr1,095.98
You save:  SEK kr328.82
ARS$61,365.44
List Price:  ARS$87,668.68
You save:  ARS$26,303.23
Bs484.79
List Price:  Bs692.59
You save:  Bs207.79
COP$272,495.59
List Price:  COP$389,296.10
You save:  COP$116,800.51
₡35,128.88
List Price:  ₡50,186.26
You save:  ₡15,057.38
L1,728.92
List Price:  L2,470
You save:  L741.07
₲521,305.22
List Price:  ₲744,753.66
You save:  ₲223,448.44
$U2,682.06
List Price:  $U3,831.68
You save:  $U1,149.62
zł282.11
List Price:  zł403.03
You save:  zł120.92
Already have an account? Log In

Transcript

Hello. So now let's start for developing dashboards Everything is ready for us we created all model views which we need to build the dashboard. So, the first thing you will do you will both will you you will design your visually out. So, as I said here I need to split this page to one left hand side with statistic on the right hand side will be the graphs. So, I will use binary splitter here. So, first I would add it if Benedict splitter component, I think you should know it which will split the page into part one and two and the split size will be 200 by default, we can make it 300.

Okay to display the four graphs here in the second hundred The second hand left hand right. So we can add something called banding dashboard. In the band dashboard here we will add a four panel box. Each pendant books will have the graph Okay, just we'll give this books number of column we need only two columns and the row height, we can say it is 50% because we'll be to once a bitch Toros it's a bitch to be 50% Okay, the first panel group we can play. First one will be number of student class can see See you then in verse rule he can see teach teachers and give us true we can see here average bus tudents last year here student in great not just like title here Okay, so this is we will drag the video view as a graph we create a graph here, here in this left hand side I will add here we can add like banner group, we can open the group.

And inside this pennant group we will add statistics legs account which for each for count for each statistics which we have here. So let's keep this in the in the last let's now start for creating the graph. So, creating a graph component graph is easy The main thing is the query and how to build the query and the queries of your object. This will be easy. So a student in classroom you will go to the student in classroom. This is number of students in class and you will drag this to you here And you can select here short.

From the short you can select what type of graph you want here, it says displays this as a bar graph like this. and here if you want to display some information in the right hand side or no need for information just displayed like bar graph like this to keep some space or don't use our 40 space you can use it like this. So I will select this as a bar graph. Here he will ask you for the x and y so we can say is a classroom maybe can be x and the bar will be like this. So you can see for each classroom number of students for each classroom or you can select make it like this. So you can have here the count for depending on what you what you wanted x and what you want and why.

So actually x should have our classroom and y should have account so just make it like this. Okay, and press OK. So now let's go to the dashboard. Here you will find our bar short bar graph. As you can see, here, there are some animation if you want to make some animation. His appearance is gonna animation indicator all or none okay is titled behavior there are some things if you want to do for initial tune if you want to make selection listener okay or trigger if you want to make a washer trigger there are some information here if you want to have a look on this all what I needed to do is I will make just as if is rich with okay this is what was on teacher classroom we can make this like a bar graph so, this is drag this teacher here as a short and they will select the boy like this.

Here here's a Why will be the count and the Classroom will be like this okay sorry if this rich with ticket Coby so this is the average boss of students so we can add as a coach here to be like, watch like this. Okay, so here our variable minimum variable was B zero maximum was b 100 you'd like to use storage with And last one is student in great numbers. So we can see student in grid here. I will select it and select chart, maybe I want to make something, maybe a line can create like a line graph, just to see how it will work. So the grid number will be our x and the line will be account B like this. And release Okay.

Here we go. Okay. As I told you in the bundle books, you're an option. You can either you can't show maximize should be always so it has to do one by one in case if you want to maximize the graph let's have a look how this now will looks like. If we run the dashboard now, we should see some graph some data in the graph okay so now we can see some patterns or graph coming in. You can just if you want to watch this, this board will have the we will have the statistics here, here to come point average boss.

Here's the line, Felicia grade grade one has five grade three For one, so this is as a line graph. This is the tissue in each classroom so you can see here value four or nine, two and so on for each classroom here classroom Yes, ready he won for you here nine. This is to teach classroom you can just maximize if you want to maximize it like this, so it looks okay so in this video now we just develop this bar so next video we can go and work in the statistics part. So see you next tivity

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.