Home » Developer & Programmer » Reports & Discoverer » Bar Graph - Grouped/Stacked (Oracle 6i Graphics Builder)
| Bar Graph - Grouped/Stacked [message #604083] |
Mon, 23 December 2013 22:56  |
 |
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
|
Member |
|
|
Hi everyone,
I've a problem regarding graphs in 6i. My requirement is to show three vertical bars (Allocation amount, Commitment amount, Payment amount) against given budget heads. Whereas, the Allocation bar should be broken into two parts (Initial, Re-appropriations), and Commitment bar should also be broken into two parts (Through Demand, Through Other); however, last bar should remain as it is. Amounts normal exceed millions.
I'm facing problem in creating above type of graph. Also the amounts are not shown on bars. The amount values on y-axis are showing "#####" as it is not re-sizeable.
Can anybody help me?
-
Attachment: graph.JPG
(Size: 26.50KB, Downloaded 1807 times)
|
|
|
|
|
|
| Re: Bar Graph - Grouped/Stacked [message #604204 is a reply to message #604184] |
Thu, 26 December 2013 04:20  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As noone replied (yet), here you go: I don't know the answer to your question(s). I don't have Developer Suite 6i so I can't test it myself. Someone else might try to replicate what you are saying, but - in order to do that, we'd need a test case (that includes CREATE TABLE and INSERT INTO sample records). Based on that input, explain a desired output - what goes to X and Y axis, which Y values you expect for each X value, etc. Even then, there's no guarantee that you'll get the answer.
If you are desperate, consider hiring a consultant.
|
|
|
|
|
|
|
|
|
|
| Re: Bar Graph - Grouped/Stacked [message #604239 is a reply to message #604220] |
Thu, 26 December 2013 09:45 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Me, sarcastic? Where did you get THAT from? All I said is legitimate. You asked a question, I said that I can't provide an answer out of my pocket. Simply put, I don't know it.
I asked you to provide certain information which might help other forum members work on a solution you are looking for (as of me - I could give it a try on my 10g installation (which is probably different from 6i, but that's the best I can offer)), but you chose not to. That's fine, nobody here will complain about it. Forum members are willing to spend their free time to solve someone else's problems, free of charge. You, of course, know that this time of year is kind of special and many people spend it with their families rather than answering questions of (mostly) unknown people asked on Internet forums. However, you are impatient.
So: if you don't want to help us help you & if you're in a hurry, the solution is very simple: hire a consultant. He/she will do that job for you; of course, not free of charge, but that's how it goes.
As of you telling me (not) to answer your (or anyone else's) questions: that's most probably not going to happen. You can, of course, ignore me (there's a link in the upper right corner of every message, saying "ignore all messages by this user"). Note that I won't lose anything, but you might; you can never tell.
Best of luck with such an attitude, you'll need it!
|
|
|
|
|
|
| Re: Bar Graph - Grouped/Stacked [message #604261 is a reply to message #604260] |
Fri, 27 December 2013 00:31 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Excellent! I'm glad you solved it!
However, I'm more interested in this part of your question:
1982Hashmi
the Allocation bar should be broken into two parts (Initial, Re-appropriations), and Commitment bar should also be broken into two parts (Through Demand, Through Other); however, last bar should remain as it is
How did you solve that?
If you didn't (yet), here's what I think about it: graph displays results of a query. Therefore, you should write a query which will return data in a desired format. I guess that DECODE or CASE might come handy in this case, maybe even some kind of grouping (analytic functions? Perhaps, but they don't work in Reports 6i so if it turns out that they are helpful, consider creating a view (in a database) and then write SELECT statement in your report which fetches data from that view). Can't tell for sure, I don't have any test data to check it myself.
On the other hand, the solution could be rather simple but I don't see it; someone else might so - wait a little bit more.
|
|
|
|
| Re: Bar Graph - Grouped/Stacked [message #604263 is a reply to message #604261] |
Fri, 27 December 2013 01:08 |
|
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
|
Member |
|
|
I'm already using a view based on DB tables. There are separate columns for all bars/stacks.
But still unable to create grouped/stacked bars as there is no template available for that in Graphics Builder 6i. May be it could be done by other ways.
I'm adding the test data script below. ALLOC_HEAD will go to x-axis. INITIAL_ALLOC & FRESH_ALLOC is the first bar, COMMITMENT_OTHER & COMMITMENT_PROC is the second bar, and PAID_BY_FIN is the third bar.
CREATE TABLE COMMITMENT_VIEW_CFY
(
ALLOC_HEAD VARCHAR2(50),
INITIAL_ALLOC NUMBER(15,3),
FRESH_ALLOC NUMBER(15,3),
COMMITMENT_OTHER NUMBER(15,3),
COMMITMENT_PROC NUMBER(15,3),
PAID_BY_FIN NUMBER(15,3)
);
SET DEFINE OFF;
Insert into COMMITMENT_VIEW_CFY
(ALLOC_HEAD, INITIAL_ALLOC, FRESH_ALLOC, COMMITMENT_OTHER, COMMITMENT_PROC, PAID_BY_FIN)
Values
('411', 3855000, 13145000, 8042053.4, 0,
6468475);
Insert into COMMITMENT_VIEW_CFY
(ALLOC_HEAD, INITIAL_ALLOC, FRESH_ALLOC, COMMITMENT_OTHER, COMMITMENT_PROC, PAID_BY_FIN)
Values
('340', 163000, 337000, 175150, 0,
163150);
Insert into COMMITMENT_VIEW_CFY
(ALLOC_HEAD, INITIAL_ALLOC, FRESH_ALLOC, COMMITMENT_OTHER, COMMITMENT_PROC, PAID_BY_FIN)
Values
('140', 6930000, 2880000, 4534100, 0,
658300);
Insert into COMMITMENT_VIEW_CFY
(ALLOC_HEAD, INITIAL_ALLOC, FRESH_ALLOC, COMMITMENT_OTHER, COMMITMENT_PROC, PAID_BY_FIN)
Values
('512', 825000, 3175000, 691505, 0,
534505);
Insert into COMMITMENT_VIEW_CFY
(ALLOC_HEAD, INITIAL_ALLOC, FRESH_ALLOC, COMMITMENT_OTHER, COMMITMENT_PROC, PAID_BY_FIN)
Values
('447', 69000, 2931000, 0, 0,
0);
COMMIT;
[Updated on: Fri, 27 December 2013 01:37] Report message to a moderator |
|
|
|
| Re: Bar Graph - Grouped/Stacked [message #604278 is a reply to message #604263] |
Fri, 27 December 2013 04:31 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
This is what you said in your first message:
Quote:My requirement is to show three vertical bars (Allocation amount, Commitment amount, Payment amount) against given budget heads. Whereas, the Allocation bar should be broken into two parts (Initial, Re-appropriations), and Commitment bar should also be broken into two parts (Through Demand, Through Other); however, last bar should remain as it is.
This is contents of a table:
ALLOC_HEAD INITIAL_ALLOC FRESH_ALLOC COMMITMENT_OTHER COMMITMENT_PROC PAID_BY_FIN
---------- ------------- ----------- ---------------- --------------- -----------
411 3855000 13145000 8042053.4 0 6468475
340 163000 337000 175150 0 163150
140 6930000 2880000 4534100 0 658300
512 825000 3175000 691505 0 534505
447 69000 2931000 0 0 0
I have difficulties in mapping these two messages. What is, for example, "Payment amount"? Is it PAID_BY_FIN? Where can "Re-appropriations" be found in this table? How to know which values represent "Through Demand" and which "Through Other"?
|
|
|
|
| Re: Bar Graph - Grouped/Stacked [message #604287 is a reply to message #604278] |
Fri, 27 December 2013 08:49 |
|
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
|
Member |
|
|
Sorry to include the detail.
First Bar:
1) Initial Allocation is the INITIAL_ALLOC column
2) Re-appropriations is the FRESH_ALLOC column
Second Bar:
3) Commitment through demand is the COMMITMENT_PROC column
4) Commitment through other is the COMMITMENT_OTHER column
Third Bar:
5) Payment amount is the PAID_BY_FIN column
|
|
|
|
Goto Forum:
Current Time: Tue Jan 21 13:00:15 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
