I want to display the graph by using two across fields like this..
GRAPH FILE TABLE1
ACROSS QUARTER AS ' ' COLUMNS 'QTR1' AND 'QTR2' AND 'QTR3' AND 'QTR4'
I am getting the graph right with appropriate values. On x-axis instead of displaying the year I want to display the quarter value like qtr1 qtr2 etc., now it displays 2003 and 2004 years.
How can I do that?
One more question is:
When a user clicks on a quarter it should show the detail part of what accounted for those total dollars. How do I pass the value for a quarter.
If I type
Quarter=A2. It is taking the year value instead of quarter value.
Thanks in advance.
I figured out how to do this. I guess graph does not allow two ACROSS fields. I joined two fields in to one in my DEFINE statement.
But now I have one more problem.
For Across field, I need to diplay all the 8 columns(2year data: 8 quarters) no matter what the field value is. In my graph, if one of the columns has zero dollars, it is not showing up in the Graph. How do I make the graph display 8 quarters eventhough one of the quarters has zero dollars.
My code is like this:
this is for a bar graph
GRAPH FILE XXX
ACROSS QTRY AS ' '
So now on my Y-axis, I get dollars for each quarter on X-axis. But when a quarter has zero dollars the graph skips that quarter and displays rest of the quarters.
Any idea how to deal with this?
|<Pietro De Santis>|
This works in a TABLE so it should work in a GRAPH:
ACROSS DAY_DESC AS ''
COLUMNS MON AND TUE AND WED AND THU AND FRI AND SAT AND SUN
In your case the COLUMNS statement would be:
COLUMNS 2003-01 AND 2003-02 AND 2003-03 AND 2003-04
AND 2004-01 AND 2004-02 AND 2004-03 AND 2004-04
The values in the COLUMNS statement may have to Dialog Manager variables that you create based on the selected years for the graph.This message has been edited. Last edited by: <Mabel>,
This works like a charm.
I did this previously, not sure why it did not work at that time though. Might have done some mistake. Thanks a lot Pietro.
|Powered by Social Strata|