Focal Point
[SOLVED] Conditional Graph Fill Color

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/892109433

January 07, 2010, 09:27 AM
ColdWhiteMilk
[SOLVED] Conditional Graph Fill Color
I found this thread that talks about changing the fill color of a graph.

[URL=https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9821077491?r=3251000591#3251000591[/URL]

Is it possible to change the fill color of the bar on the graph based on the value, so that if the value is 1-10 it would be green, 11-20 it would be yellow, and 21 or more it would be red?

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


Production - 7.6.4
Sandbox - 7.6.4
January 07, 2010, 10:03 AM
GinnyJakes
You'd probably have to determine the color ahead of time, put it in an amper variable, and use the variable in the API syntax.


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
January 07, 2010, 10:18 AM
ColdWhiteMilk
This appears to be working:

TYPE=DATA, COLUMN=N2, COLOR=BLUE, WHEN=CT_DAYS LT 14,$
TYPE=DATA, COLUMN=N2, COLOR=LIME, WHEN=CT_DAYS LT 19,$
TYPE=DATA, COLUMN=N2, COLOR=YELLOW, WHEN=CT_DAYS LT 24,$
TYPE=DATA, COLUMN=N2, COLOR=RED, WHEN=CT_DAYS GT 25,$



Production - 7.6.4
Sandbox - 7.6.4