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

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.

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.

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>';

I see that didn't come through very well, inside of the ' is "<" followed by "img"

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

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,

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,$

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, 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

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,

Ginny,

Thanks very much for that - works like a charm.

Cheers,

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.

"Use the GUI"? Yikes!

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...

You beat me to it! I still prefer the method in your article though, less chunky and so adaptable

T

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

Kinda got lost with this one

Did a repost and rephrased the question

Dan

He wants arrows.