Hello,

I'm trying to create a VLNSTKPC (stacked vertical connected point plot graph showing
percentages) graph type but without success.

Can anybody post an example?

Thanks in advanced,
Carlos Dias

This message has been edited. Last edited by: Kerry,

quote:

graph type but without success

What did you try ?

Did you get errors ?

Did you get something out ?

I've never used this graph before, but I think this is right.

Just a guess though.

DEFINE FILE CAR
 MAXCOST/I9 = RETAIL_COST ;
END
TABLE FILE CAR
SUM MAXCOST
BY COUNTRY
SUM COMPUTE PRICEPCT/P6.2 = RETAIL_COST / MAXCOST ;
    COMPUTE CONVERTIBLE/P6.2 = IF BODY EQ 'CONVERTIBLE' THEN PRICEPCT ELSE 0 ;
    COMPUTE HARDTOP    /P6.2 = IF BODY EQ 'HARDTOP    ' THEN PRICEPCT ELSE 0 ;
    COMPUTE SEDAN      /P6.2 = IF BODY EQ 'SEDAN      ' THEN PRICEPCT ELSE 0 ;
    COMPUTE COUPE      /P6.2 = IF BODY EQ 'COUPE      ' THEN PRICEPCT ELSE 0 ;
    COMPUTE ROADSTER   /P6.2 = IF BODY EQ 'ROADSTER   ' THEN PRICEPCT ELSE 0 ;

BY COUNTRY
BY BODY
ON TABLE HOLD AS TMP_GRPH
END

GRAPH FILE TMP_GRPH
 SUM CONVERTIBLE
     HARDTOP
     SEDAN
     COUPE
     ROADSTER
 ACROSS COUNTRY
 ON GRAPH SET LOOKGRAPH VLNSTKPC
 ON GRAPH SET GRAPHEDIT OFF
END

Here's my case:

TABLE FILE MY_TABLE
SUM PCT.CNT.APPLICATION AS PCT
BY LOWEST RECEIVETIME AS TIME IN-GROUPS-OF 1
WHERE (YEAR EQ &year) AND (D_TIME.MONTH EQ &month);
WHERE RECEIVETIME IS NOT MISSING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS GRAPH_IN_TIME FORMAT FOCUS
END
-RUN

GRAPH FILE GRAPH_IN_TIME
SUM COMPUTE CUME_PCT/D12 = CUME_PCT + PCT;
BY TIME IN-GROUPS-OF 1
 ON GRAPH SET LOOKGRAPH VLNSTKPC
 ON GRAPH SET GRAPHEDIT OFF
END

When I use the VLNSTKPC the values ​​always appear at 100%.



Your example works fine. The trick is the way you calculate the percentage? Or using the ACROSS?

This message has been edited. Last edited by: Carlos Dias,

Carlos

What does your result look like if you report it in a table instead in a graph?

Repro-ing with one of the sample tables would help us.

I think the difference between my case and the example of Waz is that the SUM only have one column. If in the example of Waz we use only one column the behavior is the same.

I am currently considering the graph as the type VLINE and works, but appears in the values ​​of the YYs axis 120%, although there is no number in this series. How can I limit to just stay at 100%?

Thanks in advanced,
Carlos Dias

Carlos,

See below,

TABLE FILE CAR
  SUM PCT.CNT.DEALER_COST AS PCT
  BY LOWEST SEATS AS TIME
  ON TABLE SET PAGE-NUM NOLEAD
  ON TABLE NOTOTAL
  ON TABLE HOLD AS GRAPH_IN_TIME FORMAT FOCUS
END
-RUN

GRAPH FILE GRAPH_IN_TIME
  SUM
    COMPUTE CUME_PCT/D12 = LAST CUME_PCT + PCT;
  BY TIME 
  ON GRAPH SET LOOKGRAPH VLINE
  ON GRAPH SET GRAPHSTYLE *  
  setScaleMax(getY1Axis(),100.0);
  setY1ScaleMaxAuto(false);
ENDSTYLE
END

Thank you FreSte. You tip solve my problem.

But I can't understand how the VLNSTKPC works.