Tree Map
9.1.1.2 Chart group types
Each combination of chart type, subtype, and chart group type has a different set of required objects. A subset of the following chart group types apply to each chart type:
● For each record
● On Change of
● For all records
Once you have defined your chart type, subtype, and chart group type, you must add data to one or more of the following values:
● Category
● Total
● Series
● Label
Note
Not all of the items are available for every chart type.
Total (Y)
The Total value indicates what information is summarized on your chart. For example, to create a chart showing last year's sales for your customers, the Last Year's Sales object would be the value.
Category (X)
The Category value is used with the chart group type "On Change of". It is used to indicate when to plot the point.
For example, a chart showing Last Year's Sales for your customers uses the CUSTOMER_NAME object as the condition. Each time the category changes (the customer name changes), a point is plotted.
Series (Z)
The Series value is used with the chart group type "On Change of". It is used to specify data for a series.
Label
The Label value is used with the chart group type "For each record". It is used to display a label for the Total value.
9.1.1.2.1 Required values for chart group type "On Change of"
Not all charts have the chart group type "On Change of". For most of the chart types that do, you must have Total values and either a Category value or a Series value, or both.
Chart type Subtype Category Total Series
3D Riser All subtypes Only one value. At least one value. Only one value.
3D Surface All subtypes Only one value. At least two values. Only one value.
Area All subtypes Only one value. At least one value. Only one value.
Bar All subtypes Only one value. At least one value. Only one value.
Bubble Only one value. Three values
required: X, Y, and Size.
Only one value.
Box Plot Only one value. Only one value. Only one value.
Column All subtypes Only one value. At least one value. Only one value.
Donut Donut Not applicable Only one value. Only one value.
Multiple donut Only one value. At least one value. Only one value.
Chart type Subtype Category Total Series Proportional
multiple donut
Only one value. At least one value. Only one value.
Funnel Not applicable. Only one value. Only one value.
Gauge Only one value. At least one value. Only one value.
Histogram Only one value. At least one value. Only one value.
Line All subtypes Only one value. At least one value. Only one value.
Numeric Axis All numeric subtypes Only one value;
accepts only numeric data type.
At least one value. Optional; can accept one value.
All date subtypes Only one value;
accepts only date/
time data type.
At least one value. Optional; can accept one value.
Pie Pie Not applicable. Only one value. Only one value.
Multiple pie Only one value. At least one value. Only one value.
Proportional multiple pie
Only one value. At least one value. Only one value.
Radar All subtypes Only one value. At least one value. Only one value.
Scatter Only one value. Two values required:
X and Y.
Only one value.
Stock High-Low Only one value. Two values required:
High and Low.
Not applicable.
Open-High-Low-Close
Only one value. Four values required:
High, Low, Open, and Close.
Not applicable.
Tag Cloud Only one value. At least one value.
Can accept two
9.1.1.2.2 Required values for chart group type "For each record"
All chart types have the chart group type "For each record"; however, they do not all require the same values for this option. The Label value is optional for all chart types and subtypes.
Note
With the exception of Gantt charts, all charts with the chart group type "For each record" accept only numeric values for the Total value.
Chart type Subtype Total
3D Riser All subtypes At least one value.
3D Surface All subtypes At least two values.
Area All subtypes At least one value.
Bar All subtypes At least one value.
Bubble Three values required: X, Y, and
Size.
Box Plot At least one value.
Column All subtypes At least one value.
Donut Donut Only one value.
Multiple donut At least one value.
Proportional multiple donut At least one value.
Funnel Only one value.
Gauge At least one value.
Gantt Two values required: Start and End.
Accepts only date/time data type.
Histogram At least one value.
Line All subtypes At least one value.
Numeric Axis All subtypes At least one value.
Pie Pie Only one value.
Multiple pie At least one value.
Chart type Subtype Total
Proportional multiple pie At least one value.
Radar All subtypes At least one value.
Scatter Two values required: X and Y.
Stock High-Low Two values required: High and Low.
Open-High-Low-Close Four values required: High, Low, Open, and Close.
Tag Cloud At least one value.
Can accept two values: Tags Weight and Tags Family.
Tree Map At least one value.
Can accept two values: Rectangle Weight and Rectangle Color.
9.1.1.2.3 Required values for group type "For all records"
Some chart types or chart subtypes do not have the chart group type "For all records".
Chart type Subtype Total
3D Riser All subtypes At least one value.
Area All subtypes At least one value.
Bar All subtypes At least one value.
Bubble Three values required: X, Y, and
Size.
Column All subtypes At least one value.
Donut Donut At least one value.
Funnel At least one value.
Gauge At least one value.
Histogram At least one value.
Line All subtypes At least one value.
Chart type Subtype Total
Numeric Axis All subtypes At least one value.
Pie Pie At least one value.
Radar All subtypes At least one value.
Scatter Two values required: X and Y.
Stock High-Low Two values required: High and Low.
Open-High-Low-Close Four values required: High, Low, Open, and Close.