| Graphing with Discoverer [message #298480] |
Wed, 06 February 2008 03:24  |
daibatzu
Messages: 36
Registered: September 2007
|
Member |
|
|
Hello everyone, I'm trying to build a graph in discoverer but haven't had much success. Basically, this is a sample of my worksheet. I have comma seperated the values but this is what it looks like basically. Date, Vol and Company are the headers.
Date ,Vol,Company
===================
Apr-07,100,Agip
Apr-07,200,BP
Apr-07,324,Shell
May-07,120,Agip
May-07,212,BP
May-07,332,Shell
Now I want to create a graph that plots Vol on the y axis with Date on the x axis. But for each Date, say Apr-07, I want to show seperate bars for Agip, BP and Shell. So again for May-07 on the x-axis, there will be three bars as well showing seperate bars for Agip, BP and Shell.
How do I go about this in Discoverer. I haven't had much success and would be really grateful for any help.
Many thanks
|
|
|
|
|
|
| Re: Graphing with Discoverer [message #300356 is a reply to message #298480] |
Fri, 15 February 2008 03:12  |
daibatzu
Messages: 36
Registered: September 2007
|
Member |
|
|
Thanks, I've successfully built the graph.
But there is one small issue. On the x axis, I have Jan-04, Feb-04 e.t.c as my points. Now, the issue is that these points seem to be offset a bit. By this I mean, let's say Jan-04 on the x-axis corresponds to 110,000 on the y-axis. The problem is that Jan-04, Feb-04 seems to be shifted to the left from the point of intersection of the x and y axis. How do I shift Jan-04, Feb-04 to be directly below the point of intersection? Thanks.
p.s - Trying to remember some of my highschool math here. Sorry if it wasn't too coherent.
110,000(y-axis)*
Jan-04(x-axis)
It looks something like the image above. I don't know how to add a space character here so I wasn't able to shift Jan-04. But basically there is an offset between the x-axis and the point of intersection. So I want Jan-04 to be directly below the * in discoverer. This is not really working out and I'm not sure why.
[Updated on: Fri, 15 February 2008 03:21] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Graphing with Discoverer [message #300473 is a reply to message #300433] |
Fri, 15 February 2008 09:48 |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Okay, I see what you mean. This is a bit weird indeed. Could it be that this value 'Jan-2007' (or whatever it is exactly) actually contains a number of spaces or something, that Discoverer is tryping to wrap in order to get it in the axis labels? That's the only explanation I can think of.
If not, I would suggest trying some other layouts to find out what happens (bars or something, do they show up right of the label too?)
|
|
|
|
| Re: Graphing with Discoverer [message #301218 is a reply to message #298480] |
Tue, 19 February 2008 11:22 |
daibatzu
Messages: 36
Registered: September 2007
|
Member |
|
|
Well I found a solution.
I was using Discoverer Desktop Edition to build the graphs but it seems that the Graph Wizard in that version is incomplete. Ended up using Discoverer Plus (the Java applet version on the web) and the Graph Wizard seems to have a hell of a lot more options.
I was able to choose how to center my x-axis and that has solved the problem.
Looks like Oracle wants to go Java all the way.
Thanks for the help.
|
|
|
|
| Re: Graphing with Discoverer [message #301339 is a reply to message #301218] |
Wed, 20 February 2008 02:15 |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Good point! I didn't realize that we were talking about the desktop edition and indeed in version 10g the functionality of Plus is richer then that of the Desktop edition.
Good that you found out and got it working.
|
|
|
|
| Re: Graphing with Discoverer [message #301440 is a reply to message #298480] |
Wed, 20 February 2008 11:39 |
daibatzu
Messages: 36
Registered: September 2007
|
Member |
|
|
Yes indeed. I was actually shocked to see the applet version had more features but there goes. Anyway, quite happy with this.
The only problem I have now is that I am developing this on a test instance and I wonder how I can move my work over to the production instance (i.e the workbook I have created). Will I have to do everything all over again?
|
|
|
|
| Re: Graphing with Discoverer [message #301866 is a reply to message #301440] |
Fri, 22 February 2008 01:29 |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Nope. Store the workbook in the database, do an export of it and import into the other database.
(in previous version, export of a workbook could only be done commandline, but I'm pretty sure in 10g it can be done in the Administrator interface - you would have to check the manuals).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Yeah you're right. The sketch is actually quite bizzare.