Configuring Siebel eBusiness Applications > Configuring Special Purpose Applets > Understanding How Chart Applets Are Constructed >

About Show Picklists


The Show picklist (the combo box control named ChartPickfunction) can be configured to display a selection list of field and function combinations, the selection from which determines what values are plotted along the Y axis. Multiple combinations of source field and function are provided in the selection list. The Y axis title is obtained from the text in the user's Show picklist selection.

To configure the Show picklist, the following three properties of the Chart object definition are used:

  • Data Point Field. You enter a comma-separated list of source fields, one for each entry that is to appear in the Show picklist. The first entry in the list is the default. If only one field name is entered, it applies to all functions in the picklist.
  • Data Function. You enter a comma-separated list consisting of the following function names: SUM, COUNT, AVERAGE, or PLOT. PLOT indicates that the Y values are derived directly from the values in the source field. The order in the comma list determines the association with a data point field and title (picklist function). If the comma-separated list is omitted or it contains fewer elements than the list of names in the Picklist Functions property, the list Sum,Count,Average,Plot is substituted.
  • Picklist Functions. You enter a comma-separated list of Y-axis titles, which are also the text which appears in the picklist. The order in the comma list determines the association with a data point field and data function.

For example, you could configure a Show picklist with explicit syntax that offers three choices: Number of Opportunities, Opportunity Revenue, and Opportunity Expected Revenue. This is configured with the property settings shown in Table 59.

Table 59.  Show Picklist Properties for Sales Method Bar Chart
Property
Value

Picklist Functions

Number of Opportunities, Opportunity Revenue, Opportunity Expected Revenue

Data Function

Count,Sum,Sum

Data Point Field

Name,Revenue,Expected Revenue

As can be seen from the table, there are three values in each comma-separated list. The first entry, Number of Opportunities, performs a Count function on the Name field. The second entry, Opportunity Revenue, performs a Sum function on the Revenue field. The third entry, Opportunity Expected Revenue, performs a Sum function on the Expected Revenue field.

An example of a Show picklist configured with implicit syntax and the standard function list is in the Lead Source Analysis chart in the Opportunity New Business Analysis view in Siebel Sales (Oppty Chart Applet - New Business). The picklist offers three choices: Number of Opportunities, Opportunity Revenue, and Average Opportunity Revenue. This is configured with the property settings shown in Table 60.

Table 60.  Show Picklist Properties for Lead Source Analysis Chart
Property
Value

Picklist Functions

Number of Opportunities,Opportunity Revenue, Avg Opportunity Revenue

Data Function

Count

Data Point Field

Revenue

The value of Revenue in the Data Point Field property applies to all entries in the picklist.

The value of Count in the Data Function property is unnecessary; it could be left blank instead. Whenever the number of entries in the Data Function property is not the same as the number in the Picklist Functions property, the system supplies a standard Data Function list. This list is the following:

Count,Sum,Average,Plot

The first picklist entry, Number of Opportunities, performs a Count function on the Revenue field. The second entry, Opportunity Revenue, performs a Sum function on the same field. The third entry, Avg Opportunity Revenue, performs an Average function.

This means of configuring Show picklist behavior predates the ability to specify triplets of name, function, and field, and is more restrictive. It has been retained for backwards compatibility with earlier versions of Siebel applications. Generally it makes more sense to explicitly specify the values in the three properties.

Configuring Siebel eBusiness Applications