Properties of the Chart Object

To create the data mapping from the business component to the chart applet, you must define the properties of the Chart object that this topic describes. For situations where these properties are configured differently, see How Siebel CRM Creates a Chart Applet and Siebel Object Types Reference.

The following table describes properties of the Chart Object.

Property Description

Category Field

Contains the name of a text or date field in the business component except for a scatter chart that uses a numeric category field. When Siebel CRM scans the business component records, it maps the different values in this field to different categories. It displays values on the X-axis labels of the chart.

Data Point Field

Can contain the name of a numeric field in the business component or is not defined:

  • If it is defined, then Siebel CRM adds the value in this field in each record to the total for the value of the category field in the same record.

  • If it is not defined, then Siebel CRM increments the count for the corresponding category field.

These counts or totals determine the height along the Y-axis of a bar or line point for each unique category field value in the line. Rather than a total or a count, some other function that is defined in the Data Function property can determine how to use the data in the Data Point Field property.

Series Field

Contains the name of a text field in the business component, or is not defined. When Siebel CRM scans the business component records, it maps the different values in this field to different lines. It displays these values on the legend labels of the chart.

If the number of series exceeds 50 when the user runs the chart, then Siebel CRM displays an error message. The user might be required to run another query that results in a display that does not exceed 50 series.

Function

Determines how Siebel CRM converts data point field values into the cell values of the new table. The following values are available:

  • Sum. Simple addition.

  • Count. The number of occurrences of a cell value.

  • Average. The average value for each record.

  • Plot. Similar to Count except that if a cell is empty, then the value is NULL instead of 0.