Pie - Data360_Analyze - 3.12

Data360 Analyze Server Help

Data360 Analyze
Product family
Product name
Data360 Analyze
Data360 Analyze Server Help
First publish date

This deprecated node depicts percentage share of comparable items in a pie format.

This node has been deprecated and will not be supported in a future release.



Specify the name of a single field that contains the values for the pie chart. This field must be of type int, long, or double.

A value is required for this property.


Specify a title for the chart.

A value is required for this property.


Specify the name of a single field that contains the series for the pie chart. The specified field may contain string, unicode, int, long, double, date, time or datetime data.

A value is required for this property.


Optionally specify a list of values; either enter exact field names or strings with "*" or "?" wildcards. Using these fields, this property defines a string filter on the series name whose matches are displayed in entirety while the rest of the values are summed and displayed as a single series. If you do not want to perform this action, this property can be left blank.


Optionally specify a positive, integer value to define the maximum number of series that will be displayed in their entirety. The smallest series will be summed and displayed as a single series while the largest series will be displayed entirely. If you do not want to perform this action, this property can be left blank.


Optionally specify whether the 'All Others' series is displayed when you turn on series focusing. If set to False, the 'All Others' series is not displayed. If series focusing is turned off, then this property has no effect.

The default value is True.


Optionally specify the name of the fields (column names) that you want to sort the input and output data by. This feature is useful when the XAxisField (for Area, Radar, Line, or Bar charts) or the SeriesField (for Pie charts) is string or Unicode since you can then sort the input data in different ways other than just alphabetical order. If the field data is of a numeric type, then the chart will simply display it in numerical order regardless of how it is input. If this field is blank, then a sort is not performed.

Enter the column names in the order that you want to sort on, separated by a comma. You can enter as many fields as you want and reverse any number of the specified fields by using the Script .reverse() function. To sort by multiple columns in descending order, use the following format where value is the name of the input fields that you want to sort by:reverse (list(value_1, value_2, value_3))

This property uses the same syntax as the CompareOrderExpr property in a Sort node.


Optionally specify a template for labels that are applied to all chart types except Area. These templates can contain regular text or the charted values themselves. In order to place the X-axis value, Y-axis value, and series name in the template, use "#X", "#Y", and "#Series". All other text containing "#" is left as is along with any text not prefixed with "#".

If you leave this property blank, labels for all chart types are turned off. Note that Area charts only supports labels if the X-axis data is not numeric.


Optionally specify whether to display the legend.

The default value is True.


Optionally specify the size of the image to be output.

The default is set by your server administrator, for example: 1024, 768.


Optionally specify one or more statements, in the following format, to override the default colors of all the elements in a series:


Wildcards are allowed and the following colors are accepted: black, blue, cyan, darkgray, gray, green, lightgray, magenta, orange, pink, red, white, and yellow. Color names are not case-sensitive.

If this property is left blank, then only the default colors are used. The statements specified in the FieldColors property will be run in the order that they are specified, therefore it is important to ensure that you do not write the statements in an order that causes one to overwrite the other.

For example, to highlight a single series named "Data360" in magenta, and keep all other elements in the chart using the default colors, enter:


You can ensure that your highlighting stands out by manually setting all other elements to a more sedate color, as in the following example:


Note that in this example, the gray statement comes first, followed by the magenta statement. This ensures that the gray statement first sets all series to the color gray, then the magenta statement colors only the "Data360" series. As a counterexample, if the statements were reversed then all of the elements would be colored gray (the first line will color the Data360 series magenta, but then the second line will overwrite all series with gray), as follows:



Optionally specify whether the node will fail if duplicates are detected. A duplicate is defined as two or more points that have the same X-axis value and Series name.

If set to false, if the input data contains duplicates, the behavior of this node is completely undefined: it may error, it may display only the last instance of the duplicates, or it may display all duplicates.

This property allows you to optimize a chart node by turning off duplicate detection.


Optionally specify how to handle NULL values in the X-axis, Y-axis, or diameter, if present. Choose from:

  • Error - The node fails if there are any NULLvalues.
  • Set to Zero - Any NULL value is treated as a zero value. Date values are set to 1900-01-01, and time values are set to midnight. Datetimes are set to 1900-01-01 00:00:00.
  • Suppress Point - Removes NULL values in any field.

The default value is Set to Zero.

Inputs and outputs

Inputs: Input Data, Multiple optional.

Outputs: Prepared Data, Chart Data, Chart, Multiple optional.