Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Showing Results in Funnel Charts

Use the Funnel Chart view to show results as a three-dimensional chart that represents target and actual values and levels by color. Typically, funnel charts are used to graphically represent data related to stages in a process, such as the amount of potential revenue shown for each sales stage.

Funnel charts are well suited for showing actual compared to targets for data where the target is known to decrease (or increase) significantly per stage, such as a sales pipeline. You can click on one of the colored areas to drill down to more detailed information.

In funnel charts, the thresholds indicate a percentage of the target value, and colors provide visual information for each stage:

  • All stages for which the actual value falls below the minimum threshold are colored in red.
  • All stages for which the actual value falls below the maximum threshold are colored in yellow.
  • All stages for which the actual value is greater than the maximum threshold are colored in green

To add or modify a Funnel Chart view

  1. In Siebel CRM On Demand Answers, create or modify the report with which you want to work, and then perform one of the following actions:
    • To add a new Funnel Chart view, navigate to the Create Layout page, click the Add View button, and select Advanced > Funnel Chart from the views drop-down list.
    • To edit an existing Funnel Chart view, navigate to the Create Layout page, find the Funnel Chart view, and then click the Edit View button for the Funnel Chart view.

      The workspace shows the options and settings for the Funnel Chart view.

  2. Make your selections for the fields in the workspace.

    The following table describes the fields.

    Funnel Chart View Workspace Field

    Description

    Chart Title

    Specifies the title to display at the top of the chart.

    Stage

    Identifies the stage to represent, from the drop-down list. These values are shown on the horizontal axis.

    Actual Value

    Specifies the actual value for the stage, a column selected from the drop-down list.

    Target Value

    Specifies the target value for the stage, a column selected from the drop-down list.

    Target value for final stage only

    Indicates whether the target value should appear for each stage or for the final stage only.

    Factor required to meet target

    Identifies the factors required to meet targets.

    Minimum Threshold

    Specifies the minimum threshold. Values below this percentage will appear in red. Values between this percentage and the Maximum Threshold will appear in yellow.

    Maximum Threshold

    Specifies the maximum threshold. Values above this percentage will appear in green.

    Size

    Specifies the size.

    Force standard shape and equal stage widths

    Indicates whether Siebel CRM On Demand Answers will automatically force the display.

    Interaction

    Indicates the level of interaction allowed in the chart. Choices include None, Drill, and Navigate.

  3. Select the Display Results check box to preview the Funnel Chart view.
  4. Click OK to return to the Layout Views page. Use the following buttons to move around and position the Funnel Chart view (and other views, as required) on the page:
    • Move View Right button - select this button to move the Funnel Chart view across the page to the right.
    • Move View Up or Move View Down button - select this button to move the Funnel Chart view up or down the page.
    • Format View button - select this button to format the appearance of the Funnel Chart view. You can specify Cell, Border, Background, and Additional Formatting Options (Width, Height, Indent, Right Padding, Top Padding, Bottom Padding) here.
    • Edit View button - select this button to edit the Funnel Chart view.
    • Delete View button - select this button to delete the Funnel Chart view.
  5. When you are done, you can save the report with the Funnel Chart view.

Published May 2008