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.
Hopefully, this is just something little I am missing. I have a line graph with 5 lines over a date range. The dates on the graph don't line up with the data on the graph. The toot tip shows the data "Screened 25 May 2010 57", but that tool tip should be showing the data from 26 May. http://i855.photobucket.com/al...rnell/line_graph.jpg
The code is here:
GRAPH FILE SUBJECTS
SUM COMPUTE NUMSCR/I10 = LAST NUMSCR + NUM_SCR; AS 'Screened'
COMPUTE NUMSF/I10 = LAST NUMSF + NUM_SF; AS 'Screen Failed'
COMPUTE NUMRAND/I10 = LAST NUMRAND + NUM_RAND; AS 'Randomized'
COMPUTE NUMDISCON/I10 = LAST NUMDISCON + NUM_DISCON; AS 'Withdrawn'
COMPUTE NUMCOMP/I10 = LAST NUMCOMP + NUM_COMP; AS 'Completed'
ACROSS FMT_EVENT_DM
WHERE EVENT_DM GE '&NEWFROMDATE';
WHERE EVENT_DM LE '&NEWTODATE';
ON GRAPH HOLD AS SUBGR FORMAT HTMTABLE
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS &VAXISS
ON GRAPH SET HAXIS &HAXISS
ON GRAPH SET GRAPHSTYLE *
setFillColor(getSeries(0), new Color(82,104,161));
setFillColor(getSeries(1), new Color(254,197,101));
setFillColor(getSeries(2), new Color(127,163,214));
setFillColor(getSeries(3), new Color(167,211,125));
setFillColor(getSeries(4), new Color(249,161,94));
setBorderColor(getSeries(0), new Color (82,104,161));
setBorderColor(getSeries(1), new Color (254,197,101));
setBorderColor(getSeries(2), new Color (127,163,214));
setBorderColor(getSeries(3), new Color (167,211,125));
setBorderColor(getSeries(4), new Color (249,161,94));
setSeriesLineWidthDefault(2);
setO1TitleString("");
setO1LabelAutoSkip(2);
setO1LabelSkipBegin(1);
setO1LabelSkipCount(1);
setO1LabelRotate(3);
setFrameDisplay(false);
setTextString(getY1Title(),"");
setDisplay(getY1Title(),true);
setY1LabelDisplay(true);
setMarkerDisplay(false);
setPlaceSkip(getO1Label(), 0);
setO1MajorGridDisplay(true);
setO1MinorGridDisplay(false);
setO1MajorGridStyle(1);
setY1MajorGridDisplay(true);
setY1MinorGridDisplay(false);
setY1MajorGridStyle(1);
setBorderColor(getY1MajorGrid(), new Color (220,220,220));
setBorderColor(getO1MajorGrid(), new Color (220,220,220));
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setLegendDisplay(&TRUEFALSE);
setFillMissingData(0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
$
ENDSTYLE
END
Any help would be appreciated. ThanksThis message has been edited. Last edited by: Kerry,
Do you know what would be really great? A sample using a standard IBI file. I have some thoughts on this but not the time to re-create a possible error especially when I'm not sure about your data.
So, would you be so kind as to provide a sample of this using a file from ibisamp?
I'd be glad to help...
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
Here is the same report using the sales file. Pretty sure that is a standard file (SALES). Same results. I also created it as a table to make sure the values were being added up properly, which they were.
Examining it more, it looks like the final value is getting plotted, but the tooltip is not working on it?
GRAPH FILE SALES
SUM COMPUTE TOTDEL/I10 = LAST TOTDEL + DELIVER_AMT;
DELIVER_AMT
COMPUTE TOTOPEN/I10 = LAST TOTOPEN + OPENING_AMT;
OPENING_AMT
ACROSS DATE
ON GRAPH PCHOLD FORMAT HTML
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 400
ON GRAPH SET HAXIS 500
ON GRAPH SET GRAPHSTYLE *
setFillColor(getSeries(0), new Color(82,104,161));
setFillColor(getSeries(1), new Color(254,197,101));
setFillColor(getSeries(2), new Color(127,163,214));
setFillColor(getSeries(3), new Color(167,211,125));
setFillColor(getSeries(4), new Color(249,161,94));
setBorderColor(getSeries(0), new Color (82,104,161));
setBorderColor(getSeries(1), new Color (254,197,101));
setBorderColor(getSeries(2), new Color (127,163,214));
setBorderColor(getSeries(3), new Color (167,211,125));
setBorderColor(getSeries(4), new Color (249,161,94));
setSeriesLineWidthDefault(2);
setO1TitleString("");
setO1LabelAutoSkip(2);
setO1LabelSkipBegin(1);
setO1LabelSkipCount(1);
setO1LabelRotate(3);
setFrameDisplay(false);
setTextString(getY1Title(),"");
setDisplay(getY1Title(),true);
setY1LabelDisplay(true);
setMarkerDisplay(false);
setPlaceSkip(getO1Label(), 0);
setO1MajorGridDisplay(true);
setO1MinorGridDisplay(false);
setO1MajorGridStyle(1);
setY1MajorGridDisplay(true);
setY1MinorGridDisplay(false);
setY1MajorGridStyle(1);
setBorderColor(getY1MajorGrid(), new Color (220,220,220));
setBorderColor(getO1MajorGrid(), new Color (220,220,220));
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setLegendDisplay(true);
setFillMissingData(0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
$
ENDSTYLE
END
I read over the troubleshooting tip, but it doesn't seem to solve the problem as there is (should be) a value for the last point. Luckily this is just a demo system at the moment so this issue is not urgent. I will have to look into it more in the future.