Scatter - Data360_Analyze - 3.12

Properties

Title

Specify a title for the chart.

A value is required for this property.

XAxisField

Specify the name of a single field that determines the values on the X axis. The type of this field may be string, unicode, int, long, double, date, time, or datetime.

A value is required for this property.

YAxisFields

Specify the name of a field or list of fields that contain the values for the Y axis.

If the SeriesField property is defined, then you must only enter a single field in the YAxisFields property. If the SeriesField property is not defined, then you may enter multiple fields in the YAxisFields property. If you enter multiple fields, you can use deterministic wildcards "?" and "*". All fields referenced in this property must have the same type and must be of type int, long, double, date, time, or datetime.

The order that fields are matched in this field is the same for all runs, even if the entire data flow is rerun or if wildcards are used. The only time that fields will be reordered is if you add or remove fields in nodes prior to this one. You can use this ordering to determine the order in which the series are displayed in the final chart.

A value is required for this property.

SeriesField

Optionally specify a single field that determines the name of the series for each data point. If this field is blank, then the series names are the names of the fields specified in the YAxisFields property. The type of this field may be string, unicode, int, long, date, time, or datetime.

XAxisRange

Optionally specify the range of the numeric scale of the X Axis in the following format:

<lower limit> - <upper limit>

This option cannot be used if the X Axis is specified by string data. In addition to standard numeric types, this option specifically supports dates, times, and datetimes.

For time data, the XAxisRange must be in the following format:

hh:mm:ss - hh:mm:ss

For date data, the format is as follows:

CCYY-MM-DD - CCYY-MM-DD

For datetime data, the format is as follows:

CCYY-MM-DD hh:mm:ss - CCYY-MM-DD hh:mm:ss

If this property is blank, the chart's X axis is automatically set to display all input data.

YAxisRange

Optionally specify the range of the numeric scale of the Y Axis in the following format:

<lower range> - <upper range>

This option cannot be used if the Y Axis is specified by string data. In addition to standard numeric types, this option specifically supports dates, times, and datetimes.

For time data, the YAxisRange must be in the following format:

hh:mm:ss - hh:mm:ss

For date data, the format is as follows:

CCYY-MM-DD - CCYY-MM-DD

For datetime data, the format is as follows:

CCYY-MM-DD hh:mm:ss - CCYY-MM-DD hh:mm:ss

If this property is blank, the chart's Y axis is automatically set to display all input data.

YAxisLabel

Optionally specify the text for the y-axis label.

If the YAxisLabel property is not populated and the YAxisFields property contains a single value, this value will be used. If the YAxisLabel property is not populated and the YAxisFields property contains more than one value, then the YAxisLabel is left blank.

Labeltemplate

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.

DisplayLegend

Optionally specify whether to display the legend.

The default value is True.

imagesize

Optionally specify the size of the image to be output.

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

FieldColors

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

Series=Color

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:

Data360=Magenta

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

*=GrayData360=Magenta

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:

Data360=Magenta*=Gray

NullValueBehavior

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.