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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Visualizations
 Login/Join
 
Platinum Member
posted
Is there some kind of field visualization that indicates like a gain or a loss. SPecifically I was thinking of up and down arrows.

Dont have much choices in my visualization library.

Dan
wf 7.1.1


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Report This Post
Platinum Member
posted Hide Post
If you are using Developer Studio, then there are hundreds of visuals. Open Windows Explorer, and point to your Dev Studio version, and seacrch for ".gif" There are arrow down, up, etc that you can use plus many more.


Release 7.6.9
Windows
HTML
 
Posts: 226 | Registered: June 08, 2003Report This Post
Virtuoso
posted Hide Post
And, besides using gifs for visualisation, you could in this case also make use of some windows fonts (wingdins or such) to display special characters in colors of your own choice.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Master
posted Hide Post
I don't know if this will help but the following (in your DEFINE) will let you place Red, Green or Orange balls next to your values.

POS_ICON/A80 = ' SRC=http://wfstage.eaglegl.com/ibi_html/images/kpi/green-ball.gif>';
NEG_ICON/A80 = ' SRC=http://wfstage.eaglegl.com/ibi_html/images/kpi/red-ball.gif>';
NEU_ICON/A80 =' SRC=http://wfstage.eaglegl.com/ibi_html/images/kpi/orange-ball.gif>';


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
Master
posted Hide Post
I see that didn't come through very well, inside of the ' is "<" followed by "img"


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
Expert
posted Hide Post
P,

The easiest way (imho) to prevent that is to enclose your code (whether it's HTML, javascript, WebFOCUS etc.) between the UBB code tags which are [ code] and [/code] (without spaces) for the start and finish of your code.

You could also use the options for disabling HTML or Pure HTML but in my experience the code tags cover all Smiler

Also, don't create a new post, go back to the original and click on the "edit" icon - which looks like a folder icon with a pencil eraser on it.

T

This message has been edited. Last edited by: Tony A,



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
Dan,you can show bars going right of zero for a + growth rate or gain, left of zero for a negative one or loss.
just put this entry in your stylesheet section of your fex.
GRAPHTYPE=DATA,COLUMN=myfield,GRAPHLENGTH=1,GRAPHCOLOR=NAVY,$
You can of course color your data, conditionally.
TYPE=DATA,COLUMN=myfield,COLOR=GREEN,WHEN=myfield GE 0,$
TYPE=DATA,COLUMN=myfield,COLOR=RED,WHEN=myfield LT 0,$




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
e.g.
TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF,FONT='ARIAL', SIZE=8, $
GRAPHTYPE=DATA,COLUMN=SALES,GRAPHLENGTH=1,GRAPHCOLOR=NAVY,$
TYPE=DATA,COLUMN=SALES,COLOR=GREEN,WHEN=SALES GE 10000,$
TYPE=DATA,COLUMN=SALES,COLOR=RED,WHEN=SALES LT 10000,$
ENDSTYLE
END


I wonder if there's a way to get the "graph" to display one colour if the value is below a threshold and another colour if it is above...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Francis, yes you can.

I couldn't get yours to work in a timely manner, but here is one that does work. I used the same conditions for both the data and the graph bar.

TABLE FILE CAR
PRINT
SALES AS 'Sales'

COMPUTE Profit/D12.2 = RETAIL_COST - DEALER_COST;
BY
COUNTRY AS 'Country'
BY
CAR AS 'Car'
BY
MODEL AS 'Model'
BY
BODYTYPE AS 'Body Type'
HEADING
"Car Sales/Profit Report"
WHERE ( COUNTRY EQ '&COUNTRY' ) AND ( CAR EQ '&CAR' ) AND ( MODEL EQ '&MODEL' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
RIGHTGAP=0.125000,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
WHEN=N5 GE 20000,
$
DEFMACRO=COND0002,
MACTYPE=RULE,
RIGHTGAP=0.125000,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
WHEN=N5 LE 5000,
$
DEFMACRO=COND0003,
MACTYPE=RULE,
RIGHTGAP=0.125000,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
WHEN=N6 GE 5000,
$
DEFMACRO=COND0004,
MACTYPE=RULE,
RIGHTGAP=0.125000,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
WHEN=N6 LT 1000,
$
GRAPHTYPE=DATA,
COLUMN=N5,
$
GRAPHTYPE=DATA,
COLUMN=N5,
GRAPHCOLOR='GREEN',
MACRO=COND0001,
$
GRAPHTYPE=DATA,
COLUMN=N5,
GRAPHCOLOR='RED',
MACRO=COND0002,
$
GRAPHTYPE=DATA,
COLUMN=N6,
$
GRAPHTYPE=DATA,
COLUMN=N6,
GRAPHCOLOR='GREEN',
MACRO=COND0003,
$
GRAPHTYPE=DATA,
COLUMN=N6,
GRAPHCOLOR='RED',
MACRO=COND0004,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
COLUMN=N5,
MACRO=COND0001,
$
TYPE=DATA,
COLUMN=N5,
MACRO=COND0002,
$
TYPE=DATA,
COLUMN=N6,
MACRO=COND0003,
$
TYPE=DATA,
COLUMN=N6,
MACRO=COND0004,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='COMIC SANS MS',
COLOR=RGB(153 51 0),
$
ENDSTYLE
END


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
oh that is sweet, Ginny. applause.
a regular GRAPHTYPE..with a WHEN= doesn't seem to work at all. that's just gotta be a bug!

I'm thinking this is Focal Point Tip of the Year from Ginny for Summit 08/Nashville

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




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
Ginny,

Thanks very much for that - works like a charm.

Cheers,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Thanks.

Use the GUI and be careful of the order. The stylesheet entries are applied sequentially and if you don't have the conditions applied in the proper order, you will get funny looking results.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
"Use the GUI"? Yikes!


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
ah i figured it out. its not a bug, its a feature.

-*---------------------------------------
GRAPHTYPE=DATA,COLUMN=PROFIT,$
GRAPHTYPE=DATA,COLUMN=PROFIT,GRAPHCOLOR='GREEN',WHEN=PROFIT GE 0,$
GRAPHTYPE=DATA,COLUMN=PROFIT,GRAPHCOLOR='RED',WHEN=PROFIT LT 0,$
-*-------------------------------------

the WHEN= just wont stand alone in a GRAPHYTYPE
(which makes sense)
You have to declare the GRAPHTYPE first.
then the WHEN= can tweak it all you want...




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
You beat me to it! I still prefer the method in your article though, less chunky and so adaptable Smiler

T

This message has been edited. Last edited by: Tony A,



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Platinum Member
posted Hide Post
Kinda got lost with this one

Did a repost and rephrased the question

Dan


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Report This Post
Virtuoso
posted Hide Post
He wants arrows.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Thanks for "pointing" that out Prarie Wink

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders