Home » Developer & Programmer » Reports & Discoverer » Graphing with Discoverer
Graphing with Discoverer [message #298480] Wed, 06 February 2008 03:24 Go to next message
daibatzu
Messages: 34
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 #300152 is a reply to message #298480] Thu, 14 February 2008 07:39 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
So, put company as the series I would say. But you will have to play around with it yourself, since we can not access your system...
Re: Graphing with Discoverer [message #300356 is a reply to message #298480] Fri, 15 February 2008 03:12 Go to previous messageGo to next message
daibatzu
Messages: 34
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 #300412 is a reply to message #300356] Fri, 15 February 2008 05:59 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
I'm afraid we're hitting some limitations in visual representation here Laughing
Sorry, but I have no clue what you mean. If it's that important to you, you might want to put a screendump in your post?
Re: Graphing with Discoverer [message #300433 is a reply to message #298480] Fri, 15 February 2008 06:53 Go to previous messageGo to next message
daibatzu
Messages: 34
Registered: September 2007
Member
Smile Yeah you're right. The sketch is actually quite bizzare.

I have included an image of the graph. You can that Jan-04 is not directly below the point of intersection.

Thanks.
  • Attachment: ivpr.gif
    (Size: 15.90KB, Downloaded 134 times)
Re: Graphing with Discoverer [message #300473 is a reply to message #300433] Fri, 15 February 2008 09:48 Go to previous messageGo to next message
skooman
Messages: 912
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 Go to previous messageGo to next message
daibatzu
Messages: 34
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 Go to previous messageGo to next message
skooman
Messages: 912
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 Go to previous messageGo to next message
daibatzu
Messages: 34
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 Go to previous message
skooman
Messages: 912
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).
Previous Topic: Parameter field and user parameters difference
Next Topic: Discoverer Calculation Help
Goto Forum:
  


Current Time: Sat Dec 10 05:09:06 CST 2016

Total time taken to generate the page: 0.05082 seconds