Controlling the Chart Type

In this section:

The recommended way to establish the chart type is to include the LOOKGRAPH parameter in your request.

FOCUS provides parameters for controlling many other chart properties, as well. Most of these also have JSON equivalents. In all cases, the best practice is to use FOCUS syntax where possible and JSON properties when a FOCUS parameter does not exist for the desired property.


Top of page

x
Controlling Chart Type Using LOOKGRAPH

How to:

Reference:

With a few exceptions, each GRAPH request must include a sort phrase (dimension) and at least one display field (measure).

The fields that are the subjects of the chart can be real or virtual fields, with or without direct operator prefixes (for example, AVE., MIN., MAX.). They can also be calculated values.

Note: Display fields used only for calculations need not appear in the chart. You can use the NOPRINT phrase to suppress the display of such fields.

The LOOKGRAPH parameter enables you to change the format of the graph without having to set individual control parameters or restructure the graph request. However, even if you use LOOKGRAPH, you can choose to set individual control parameters (for example, SET GRID=ON).



x
Syntax: How to Specify a Chart Type Using LOOKGRAPH

Prior to the request, use the following syntax

SET LOOKGRAPH= type

Or, within the request, use the following syntax

ON GRAPH SET LOOKGRAPH type

where:

type

Is the chart type you want to generate.

For a complete list of LOOKGRAPH values, see the Creating Reports manual. The following sections list the most useful LOOKGRAPH values for creating HTML5 charts.



x
Reference: Line Chart Styles

The following are LOOKGRAPH values for the most useful types of connected point plots:

SET LOOKGRAPH

Description

VLINE
 LINE

A vertical absolute connected point plot graph.

VLINE2

A vertical connected point plot graph with two axes.

HLINE

A horizontal absolute connected point plot graph.

HLINE2

A horizontal connected point plot graph with two axes.



x
Reference: Bar Chart Styles

The following are LOOKGRAPH values for the most useful types of bar charts:

SET LOOKGRAPH

Description

VBAR
BAR

A bar graph with absolute vertical side-by-side bars (columns).

HBAR

An absolute bar graph with horizontal bars.

VBRSTK1
STACK

A stacked vertical bar graph.

VBRSTKPC

A stacked vertical bar graph that shows percentages.

HBRSTK1

A stacked horizontal bar graph.

HBRSTKPC

A stacked horizontal bar graph that shows percentages.



x
Reference: Pie Chart Styles

The following is the LOOKGRAPH value for the most useful type of pie chart:

SET LOOKGRAPH

Description

PIE

A pie graph.



x
Reference: Scatter Chart Styles

The following are LOOKGRAPH values for the most useful types of scatter chart:

SET LOOKGRAPH

Description

SCATTER

Produces a scatter graph. The numeric sort field becomes the x-axis.

SCATTERN

Produces a scatter graph using a sort field of any data type. The measures (there must be two) become the axes, and the points plotted represent the sort field values.

SCATTERS

Produces a scatter graph using a sort field of any data type. Each marker represents a value of one of the measures (there can be any number), and the sort field becomes the x-axis.



x
Reference: Three-Dimensional Chart Styles

The following are LOOKGRAPH values for the most useful types of three-dimensional charts:

SET LOOKGRAPH

Description

3DAREAG

A three-dimensional connected group area chart.

3D_BAR

A three-dimensional chart with bars.

3DSURFCE

A three-dimensional surface chart that graphs all data points as a three-dimensional surface, like a rolling wave.



x
Reference: Area Chart Styles

Choose one of the following LOOKGRAPH values to change the style of area charts:

SET LOOKGRAPH

Description

VAREA

A vertical area graph.

VAREASTK

A stacked vertical area graph.

VAREAR2

A vertical area graph with two axes.

VARESTK2

A stacked vertical area graph with two axes.

VARESTKP

A stacked vertical area graph that shows percentages.

HAREA

A horizontal area graph.

HAREAR2

A horizontal area graph with two axes.

HAREASTK

A stacked horizontal area graph.

HARESTK2

A stacked horizontal area graph with two axes.

HARESTKP

A stacked horizontal area graph that shows percentages.



x
Reference: Polar Chart Styles

Choose one of the following LOOKGRAPH values to change the style of polar charts:

SET LOOKGRAPH

Description

POLAR

A polar chart that displays data points on a circle.

POLAR2

A dual polar chart. Values from an additional data set are displayed on a second value (Y) axis.



x
Reference: Radar Chart Styles

Choose one of the following LOOKGRAPH values to change the style of radar charts:

SET LOOKGRAPH

Description

RADARA

A radar area chart.

RADARL

A radar line chart.

RADARL2

A dual radar line chart. Values from an additional data set are displayed on a second value (Y) axis.



x
Reference: Bubble Chart Styles

Choose one of the following LOOKGRAPH values to change the style of bubble charts:

SET LOOKGRAPH

Description

BUBBLE

A bubble chart.

BUBBLED

A bubble chart with a dual axis.

BUBBLEDL

A bubble chart with a dual axis and labels.

BUBBLEL

A bubble chart with labels.



x
Reference: Spectral Chart Styles

Choose the following LOOKGRAPH value to generate a spectral chart (or heatmap):

SET LOOKGRAPH

Description

SPECTRAL

A spectral map chart. This is a chart with a row or column matrix of markers that is colored according to the data values.



x
Reference: Other Chart Types

Use the following LOOKGRAPH values for these advanced chart types:

SET LOOKGRAPH

Description

VWATERFL

Vertical waterfall chart. A waterfall chart does not require a sort field.

HWATERFL

Horizontal waterfall chart. A waterfall chart does not require a sort field.

PARETO

Displays data following Pareto 80:20 rule. Pareto charts require only one display field.

MULTI3Y
MULTI4Y
MULTI5Y

Stacks charts in order to make it easier to read, analyze and manage them.



x
Reference: HTML5-Only Chart Types

The following LOOKGRAPH values are valid only when generating an HTML5 chart:

SET LOOKGRAPH

Description

BUBBLEMAP

A bubblemap is a chart in which proportionally sized bubbles are displayed on relevant areas of the map.

CHOROPLETH

A choropleth is a chart in which areas on a map are shaded or patterned in proportion to the value of the measure being represented.

MEKKO

A Mekko chart is a variant of a stacked bar chart, in which the width of the bars is adjusted relative to its value in the data set.

PARABOX

A Parabox (or parallel coordinates chart) is similar to a regular line chart, except that each group in the line chart has a unique and interactive numeric axis. Each line represents one series of data. Each vertical bar represents a numeric axis. You can click and drag along each of the axes to select (filter) the lines that pass through that part of the axis

STREAM

A streamgraph is a simplified version of a stacked area chart. In a streamgraph, there are no axes, gridlines, or frames. The baseline is free, which makes it easier to perceive the thickness of any given layer across the data.

TAGCLOUD

A tagcloud is a visual representation of frequency. It displays only group labels. The size of each label is proportional to its data value.

TREEMAP

A treemap chart displays hierarchical data as a set of nested rectangles.


Information Builders