Reference: |
Bubble charts are scatter charts in which the size of each marker varies depending on the value of a measure.
The following table lists the traditional LOOKGRAPH value and the new LOOKGRAPH value.
LOOKGRAPH Parameter |
|
---|---|
Traditional |
Convert to |
BUBBLE |
BUBBLE |
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 |
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 |