Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating a Stoplight indicator
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Creating a Stoplight indicator
 Login/Join
 
Member
posted
I am looking to create a Stoplight style report/chart that would show a Red light based on the count of designated field and a Yellow light if a count of different field is a certain value and Green light if the other conditions don't exist. I am thinking there is a way to do this by importing an image based on the conditions. Does any one have any experience with displaying images conditionally?

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


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 6 | Registered: July 29, 2014Reply With QuoteReport This Post
Silver Member
posted Hide Post
Please find the car code below to display images conditionally:

TABLE FILE CAR
PRINT
CAR
DEALER_COST
RETAIL_COST
SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
DEFMACRO=Condition_1, MACTYPE=RULE, WHEN=DEALER_COST GE 2000, $
DEFMACRO=Condition_2, MACTYPE=RULE, WHEN=DEALER_COST LT 2000, $
DEFMACRO=Condition_3, MACTYPE=RULE, WHEN=RETAIL_COST GE 14000,$
DEFMACRO=Condition_4, MACTYPE=RULE, WHEN=RETAIL_COST LE 5000,$


TYPE=DATA, COLUMN=DEALER_COST, MACRO=Condition_1, IMAGE=PATH OF THE GREEN LIGHT IMAGE FILE, $
TYPE=DATA, COLUMN=DEALER_COST, MACRO=Condition_2, IMAGE=PATH OF THE YELLOW LIGHT IMAGE FILE,$
TYPE=DATA, COLUMN=RETAIL_COST, MACRO=Condition_3, IMAGE=PATH OF THE GREEN LIGHT IMAGE FILE,$
TYPE=DATA, COLUMN=RETAIL_COST, MACRO=Condition_4, IMAGE=PATH OF THE YELLOW LIGHT IMAGE FILE,$
ENDSTYLE
END
-RUN


WebFOCUS 8.0.08 - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
Windows, All Outputs
 
Posts: 40 | Registered: April 02, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating a Stoplight indicator

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.