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] Styling Data Points for a Chart in Editor

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Styling Data Points for a Chart in Editor
 Login/Join
 
Platinum Member
posted
For a bar chart in the editor, how do you style the different data points on an axis series where they are different colors? For example, if I have three risers on an axis, how would I style each one differently. This below gets me all one color for the axis for all 3 data point risers:

setFillColor(getSeries(0),new Color(0,43,73));

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Virtuoso
posted Hide Post
Say you have 3 series. Each is associated with a number starting with 0.
  
setFillColor(getSeries(0),new Color(255,0,0));
setTransparentBorderColor(getSeries(0), true);
setFillColor(getSeries(1),new Color(255,128,0));
setTransparentBorderColor(getSeries(1), true);
setFillColor(getSeries(2),new Color(128,64,0));
setTransparentBorderColor(getSeries(2), true);


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Master
posted Hide Post
Are you saying that you only have one series, and want the colors to change by the different groups?

Look at ColorMode

By using setColorMode(2); this will color by group. Example below:

 
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
BY CAR.COMP.CAR
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setCurveFitEquationDisplay(false); 
setPlace(true); 

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/endeflt.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(*), true);
setColorMode(2);
*GRAPH_JS_FINAL
"riserBevel": "none"

*END
ENDSTYLE
END

-RUN 


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Master
posted Hide Post
quote:
For a bar chart in the editor

Referencing my answer above, in the GUI editor, right click on the first bar and in the menu, go to Color Mode and select By Group.

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


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Thanks for both of your replies. Yes, I have one series and want the colors to change by the different groups. So if I use setColorMode(2), what tells it to color this group a certain color and so forth?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
How do you remove the gridlines in the code from a bar chart?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Virtuoso
posted Hide Post
  
setDisplay(getY1MajorGrid(),false);
setDisplay(getO1MajorGrid(),false);


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Master
posted Hide Post
quote:
Originally posted by AMC2:
How do you remove the gridlines in the code from a bar chart?


 
setDisplay(getO1MajorGrid(),false);
setDisplay(getY1MajorGrid(),false);
 


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Master
posted Hide Post
quote:
Originally posted by AMC2:
Thanks for both of your replies. Yes, I have one series and want the colors to change by the different groups. So if I use setColorMode(2), what tells it to color this group a certain color and so forth?


 
setFillColor(getSeries(0),new Color(255,128,0));
setFillColor(getSeries(1),new Color(0,128,0));
 


and so on for the amount of groups that you have


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Thanks for that. Also, how do you remove the outlying containers for each bar on the chart?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
quote:
Originally posted by AMC2:
Thanks for that. Also, how do you remove the outlying containers for each bar on the chart?


What do you mean by outlying container?


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
There are like a main gridline surrounding each of my bars on the bar chart. I removed the other smaller gridlines with the commands you posted earliear, but this major like gridline container is surrounding each bar. Does that make sense?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
try this for each group
 
setTransparentBorderColor(getSeries(0), true);
 


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Hallway - That did not work...it still has the outlying container around each bar. Any other ideas?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
quote:
Originally posted by AMC2:
Hallway - That did not work...it still has the outlying container around each bar. Any other ideas?


Can you post your code using the car file so I can run it on my end and see what you are seeing?


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Here is the actual code.

  

DEFINE FILE gen_use_datasources/sv_shipments
 CURR_USER/A100V=UPPER ( REPLACE ( '&IBIMR_user' , 'hills\' , '' ) ) ;
 CLAIM_FILED_BIN_1/I14=FLOOR ( SV_SHIPMENTS.SV_SHIPMENTS.CLAIM_FILED/10 ) * 10 ;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_ARVERSION=1;
SET ARVERSION=&WF_ARVERSION

-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE gen_use_datasources/sv_shipments
-* Created by Info Assist for Graph
SUM SV_SHIPMENTS.SV_SHIPMENTS.CLAIM_FILED
BY SV_SHIPMENTS.SV_SHIPMENTS.CLAIM_STATUS
BY CLAIM_FILED_BIN_1 NOPRINT
WHERE SV_SHIPMENTS.SV_SHIPMENTS.PRIMARY_RECORD EQ 'Y';
WHERE SV_SHIPMENTS.SV_SHIPMENTS.CLAIM_STATUS EQ 'FILED' OR 'RESOLVED' OR 'NEW';
WHERE SV_SHIPMENTS.SV_SHIPMENTS.LOGIN_ID EQ CURR_USER;
-INCLUDE IBFS:/WFC/Repository/Financials/Common_Content/filters_include.fex
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);

*END
-*-INCLUDE IBFS:/WFC/Repository/Sunset/Common_Content/sunset_stylesheet.sty
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=DATA, COLUMN=N1, BUCKET=row, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
*GRAPH_SCRIPT

setDisplay(getY1MajorGrid(),false);
setDisplay(getO1MajorGrid(),false);
setTransparentBorderColor(getSeries(0), true);

setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getY1Title(),true);
setTextString(getY1Title(),"Claims");
setTextFormatPreset(getY1Label(),0);
setDisplay(getO1Title(),true);
setTextString(getO1Title(),"");
-*added for individual styling
setFillColor(getSeries(0),new Color(209, 95, 39));
*GRAPH_JS_FINAL
"pieProperties": {
    "holeSize": "0%"
},
"blaProperties": {
    "orientation": "horizontal"
},
"yaxis": {
    "title": {
        "text": "Claims"
    }
},
"agnosticSettings": {
    "chartTypeFullName": "Bar_Histogram_Horizontal"
}

*END
ENDSTYLE
END

-RUN




WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
Any more thoughts on this?

Also, how do you format the X or Y axes as a dollar format in the code?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
I cannot run that as I do not have that master. Can you replicate the chart using the CAR file?


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Master
posted Hide Post
I did just have a thought though. Try removing the default bevel.
  
"riserBevel": "none",


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Is that line of code is for removing the outlying lines around the bars? Also, where specifically does it go? Does it go in the "GRAPH_JS_FINAL" section?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Master
posted Hide Post
quote:
Originally posted by AMC2:
Is that line of code is for removing the outlying lines around the bars? Also, where specifically does it go? Does it go in the "GRAPH_JS_FINAL" section?


I still don't know what you mean by "outlying lines around the bars." The code that you posted I cannot run since I don't have that metadata. If you could replicate your chart using the CAR file, I would maybe understand better. I simply suggested removing the riserBevel because it gives a darker gradient appearance on the edges.

Yes, that will go in the "GRAPH_JS_FINAL" section. Anything that is in JSON format ( "property":"value" ) will go in that section.

In InfoAssist, go to: Series (tab) > Style > Effect > Riser Style > None.


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Hallway - My apologies for taking a few days to get back. I have not had a chance to try to replicate this with the CAR file yet. Removing this line for default bevel did not do anything.

"riserBevel": "none",

However, when I added these lines you suggested before:

setDisplay(getO1MajorGrid(),false);
setDisplay(getY1MajorGrid(),false);

I get it without the gridlines, but there is just a line separating each horizontal bar now. Would really like these lines removed too.


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report This Post
Platinum Member
posted Hide Post
Also, how do you get the format of the values on the axis to be dollars...with dollar symbol...in the code?


WebFOCUS 8.2.06
SQL Server
HTML, PDF, Excel, etc
 
Posts: 168 | Registered: August 22, 2019Report 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] Styling Data Points for a Chart in Editor

Copyright © 1996-2020 Information Builders