Focal Point
An interesting problem

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4731037752

November 17, 2007, 02:08 PM
Danny-SRL
An interesting problem
This is not a question. It was something that happened at a customer's. I'll present it in terms of the CAR file.

The exercise is to produce a graph for ENGLAND JAPAN and ITALY.
On the x-axis we have SALES, RETAIL_COST, DEALER_COST.
On the y-axis the values for each country.
I have a solution which I will post. In the mean time, any proposal is welcome.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

November 17, 2007, 03:48 PM
FrankDutch
Daniel

I would do this with a multi-Y graph, although that would be limited to max 5. (the Car database has only 5, so no problem)
So tree groups of data on the x-as.
For the exact coding I need to be on the office.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

November 19, 2007, 01:22 PM
VLozovsky
Hi Danny,

See if this will do what you need:

GRAPH FILE CAR
SUM RC DC SALES
ACROSS COUNTRY
WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN' OR 'ITALY';
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHSTYLE *
setSeriesAreRows(false);
setPlace(true);
END

Vicky Lozovsky
November 20, 2007, 08:40 AM
Danny-SRL
Vicky,
Very nice! I didn't know about setSeriesAreRows(false);

I used some focus code and an alternate Master. Your solution is very elegant.
Thanks.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF