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     [CLOSED] Report and Graphs

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Report and Graphs
 Login/Join
 
MichaelBalle
Gold member
posted
Is there a posibility in WebFOCUS to display the values of the actual row as a graph with the graph as a cell in the actual row?

Means:
Country  Car             DC          RC   Graph
England  Jaguar      18.621      22.369   displaying DC and RC for Jaguar as bar graph
         Jensen      14.940      17.850   displaying DC and RC for Jensen as bar graph
         Triumph      4.292       5.100   displaying DC and RC for Triumph as bar graph

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


WebFOCUS 7.6, 7.7
Windows, All Output formats
 
Posts: 90 | Location: Stuttgart | Registered: October 20, 2010Report This Post
AlexU
Gold member
posted Hide Post
Turn on visualization for both fields by right clicking on each field and selecting "visualize"


WF 7703M, XP/Win7, MRE, RC, BID, PMF, HTML, PDF, Excel 2000/7/10
 
Posts: 73 | Location: NY | Registered: February 06, 2007Report This Post
MichaelBalle
Gold member
posted Hide Post
Hi AlexU,

this is a good idea, but i don't need the bars behind the numbers but both bars (the one for Dealer Cost and the one for Retail Cost) in one graph as a cell in the column following on the right side of Retail Cost.


WebFOCUS 7.6, 7.7
Windows, All Output formats
 
Posts: 90 | Location: Stuttgart | Registered: October 20, 2010Report This Post
PBrightwell
Master
posted Hide Post
If your output is in HTML, you could use I-FRAMES and put your report in the left frame and your graph in the right frame.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
<FreSte>
posted
You could do something like this (HTML-only Frowner )

TABLE FILE CAR
  SUM 
    DEALER_COST 
    RETAIL_COST
    COMPUTE XTOT/D12.2 = DEALER_COST+RETAIL_COST; AS ''
  BY COUNTRY 
  BY CAR
  ON TABLE SET STYLE *
    TYPE=REPORT, UNITS=POINTS, GRID=OFF,$
    GRAPHTYPE=DATA,CLASS=HIDE, COLUMN=XTOT,GRAPHLENGTH=150,GRAPHCOLOR=SILVER,$
  ENDSTYLE
  ON TABLE SET HTMLCSS ON
  ON TABLE HOLD FORMAT HTMTABLE
END
-RUN

-HTMLFORM BEGIN
<html>
<style>
.hide {
  display : none;
}
</style>
<body>
!IBI.FIL.HOLD;
</body>
</html>
-HTMLFORM END
 
Report This Post
MichaelBalle
Gold member
posted Hide Post
I tried the above version and got it with more than one bar.
But it's also not the solution.
We are looking for a report with data columns and one column containing a bar graph you can create in EXCEL.
I can't append a file with the blueprint here (its an EXCEL file).


WebFOCUS 7.6, 7.7
Windows, All Output formats
 
Posts: 90 | Location: Stuttgart | Registered: October 20, 2010Report This Post
<FreSte>
posted
Can't you make a screenprint of what you need, put that somewhere
on the web and create an url pointing to that image ??
 
Report 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     [CLOSED] Report and Graphs

Copyright © 1996-2020 Information Builders