Converting Bubble Chart Requests to Chart Attribute Syntax

Reference:

Bubble charts are scatter charts in which the size of each marker varies depending on the value of a measure.

Reference: LOOKGRAPH Conversions for Bubble Charts

The following table lists the traditional LOOKGRAPH value and the new LOOKGRAPH value.

LOOKGRAPH Parameter

Traditional

Convert to

BUBBLE

BUBBLE

Reference: Attribute Category Assignments for Bubble Charts

The following table lists the attribute category conversions for bubble charts.

Type of Column or Parameter

Attribute Category

measure field

y-axis

measure field

x-axis

measure field

size

GRLEGEND or GRXAXIS sort field

color

GRMULTIGRAPH sort field

page

Example: Converting a Bubble Chart Request to Chart Attribute Syntax

The following example generates multiple bubble charts using traditional syntax (LOOKGRAPH value is BUBBLE). The high-level sort field (BRANDTYPE) is the GRMULTIGRAPH sort field. Separate bubble charts are generated for each value of BRANDTYPE. The PRODUCT_CATEGORY sort field is the GRLEGEND sort field. By default, the legend is not visible, so the JSON visible:true property is set for the legend:

GRAPH FILE WF_RETAIL_LITE
SUM REVENUE_US 
MSRP_US 
GROSS_PROFIT_US
BY BRANDTYPE 
BY PRODUCT_CATEGORY 
ON GRAPH SET EMBEDHEADING ON 
ON GRAPH SET GRMERGE ADVANCED    
ON GRAPH SET GRMULTIGRAPH 1           
ON GRAPH SET GRLEGEND 1             
ON GRAPH SET GRXAXIS 0                 
ON GRAPH SET LOOKGRAPH BUBBLE   
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
*GRAPH_JS
"legend": {"visible": true}
*END
ENDSTYLE
END

The output is shown in the following image:

The following is the same request converted to chart attribute syntax. The LOOKGRAPH value is BUBBLE. The measures (REVENUE_US, MSRP_US, and GROSS_PROFIT_US) are assigned to the x-axis, y-axis, and size attribute categories, the high-level sort field (BRANDTYPE) is assigned to the page attribute category, and the low-level sort field (PRODUCT_CATEGORY) is assigned to the color attribute category.

GRAPH FILE WF_RETAIL_LITE
HEADING CENTER
"<BRANDTYPE "
SUM REVENUE_US 
MSRP_US 
GROSS_PROFIT_US
BY BRANDTYPE 
BY PRODUCT_CATEGORY 
ON GRAPH SET LOOKGRAPH BUBBLE
ON GRAPH SET EMBEDHEADING ON
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN = BRANDTYPE, BUCKET=PAGE,$
TYPE=DATA, COLUMN = PRODUCT_CATEGORY, BUCKET=COLOR,$
TYPE=DATA, COLUMN = REVENUE_US, BUCKET=x-axis,$
TYPE=DATA, COLUMN = MSRP_US, BUCKET=y-axis,$
TYPE=DATA, COLUMN = GROSS_PROFIT_US, BUCKET=SIZE,$
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
END

The output is shown in the following image:

WebFOCUS

Feedback