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 Go to next message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
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 51 times)
Re: Bar Graph - Grouped/Stacked [message #604184 is a reply to message #604083] Wed, 25 December 2013 21:33 Go to previous messageGo to next message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
Member
Please help me.
Re: Bar Graph - Grouped/Stacked [message #604204 is a reply to message #604184] Thu, 26 December 2013 04:20 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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 #604205 is a reply to message #604204] Thu, 26 December 2013 04:36 Go to previous messageGo to next message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
Member
Wow, what a reply.

I'm impressed...............
Re: Bar Graph - Grouped/Stacked [message #604211 is a reply to message #604205] Thu, 26 December 2013 05:39 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Nope, you're just being sarcastic (but that won't help you get the answer).
Re: Bar Graph - Grouped/Stacked [message #604220 is a reply to message #604211] Thu, 26 December 2013 07:03 Go to previous messageGo to next message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
Member
So you are. I didn't expect to get such responses from a senior member like yourself.

Please don't respond further to my questions....
Re: Bar Graph - Grouped/Stacked [message #604239 is a reply to message #604220] Thu, 26 December 2013 09:45 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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 #604260 is a reply to message #604239] Thu, 26 December 2013 23:43 Go to previous messageGo to next message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
Member
I need not to hire a consultant for this little work. I've not good experience with Oracle 6i Graphics Builder but still able to resolve it.

For bar labels use Field Template... -> Axis Field Tab -> Plot Type (Check Label)
To resize tick labels just provide a Number Format.
Re: Bar Graph - Grouped/Stacked [message #604261 is a reply to message #604260] Fri, 27 December 2013 00:31 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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 Go to previous messageGo to next message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
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 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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 Go to previous message
1982Hashmi
Messages: 31
Registered: March 2011
Location: Karachi
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
Previous Topic: Unable to create formula Column for the select
Next Topic: Character mode report Problem!
Goto Forum:
  


Current Time: Thu Jul 31 01:20:43 CDT 2014

Total time taken to generate the page: 0.13972 seconds