Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Workaround]Line Graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Workaround]Line Graph
 Login/Join
 
Virtuoso
posted
Is it possible to get the line in this graph to start at 0 instead on the first day?
The real data will be a daily graph thru the month starting on the first.

DEFINE FILE CAR
COUNTER/I3 WITH CAR = LAST COUNTER+1;
XDATE/MDYY WITH CAR = IF COUNTER EQ 1 THEN '10/01/2009' ELSE
IF COUNTER EQ 2 THEN '10/02/2009' ELSE
IF COUNTER EQ 3 THEN '10/03/2009' ELSE
IF COUNTER EQ 4 THEN '10/04/2009' ELSE '10/05/2009';

NCOST/D8 WITH CAR = IF COUNTER EQ 1 THEN 1000 ELSE
IF COUNTER EQ 2 THEN 1500 ELSE
IF COUNTER EQ 3 THEN 3000 ELSE
IF COUNTER EQ 4 THEN 5000 ELSE 7000;

END
GRAPH FILE CAR
SUM CAR NOPRINT
NCOST
ACROSS XDATE
WHERE COUNTER LE 5

ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 999
ON GRAPH SET VAXIS 580
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET VZERO ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRID ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET 3D ON
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setFillColor(getChartBackground(),new Color(212,212,212));
setLegendAutomatic(true);
setBorderColor(getLegendArea(),new Color(0,0,128));
setLegendMarkersPerRow(3);
setSeriesType(0,2);
setDepthRadius(0);
setLegendDisplay(true);
setPlace(true);
-*This rotates the legend
setTextRotation(getDataText(),2);
setTextRotation(getO1Label(),3);

setUseSeriesShapes(true);
setMarkerSizeDefault(5000);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"$###,###,###");
setScaleFromZero(true);
setZeroValueDataTextDisplay(true);

setPlace(true);
ENDSTYLE
END

This message has been edited. Last edited by: Prarie,
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
I think you need an extra data point for zero to do this.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
<JG>
posted
Best I can think of at the moment

SET NODATA=''
DEFINE FILE CAR
COUNTER/I3 WITH CAR = LAST COUNTER+1;
XDATE/MDYY WITH CAR MISSING ON= IF COUNTER EQ 1 THEN MISSING ELSE
IF COUNTER EQ 2 THEN '10/01/2009' ELSE
IF COUNTER EQ 3 THEN '10/02/2009' ELSE
IF COUNTER EQ 4 THEN '10/03/2009' ELSE
IF COUNTER EQ 5 THEN '10/04/2009' ELSE '10/05/2009';

NCOST/D8 WITH CAR MISSING ON = IF COUNTER EQ 1 THEN MISSING ELSE
IF COUNTER EQ 2 THEN 1000 ELSE
IF COUNTER EQ 3 THEN 1500 ELSE
IF COUNTER EQ 4 THEN 3000 ELSE
IF COUNTER EQ 5 THEN 5000 ELSE 7000;

END
GRAPH FILE CAR
SUM CAR NOPRINT
NCOST
ACROSS XDATE
WHERE COUNTER LE 6
 
Report This Post
Virtuoso
posted Hide Post
Thanks JG...I'll see if I can work with that thought. What I had done in the mean time was Subtraced a day from the Beginning of Month date and an NCOST of 0 , appended it to the file and had the graph start at 9/30 instead of 10/01.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Workaround]Line Graph

Copyright © 1996-2020 Information Builders