Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Working with Oracle BI Views in Oracle BI Answers >

Showing Results in a Funnel Chart Using Oracle BI Funnel Chart View

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 that changes over different periods or stages. For example, funnel charts are often used to represent the volume of sales over a quarter.

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 an Oracle BI funnel chart view

1. In Oracle BI Answers, create or modify the request with which you want to work, and then perform one of the following actions:
   • To add a new funnel chart view, click the Results tab and choose Other Views > Funnel Chart from the views drop-down list.
   • To edit an existing funnel chart view, click the Results tab, choose Compound Layout from the views drop-down list, and then click the Edit View button for the funnel chart view.

     The workspace shows the options and settings for the 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 when the chart appears.
   Stage	Identifies the stage to represent, from the drop-down list.
   Actual Value	Specifies the actual value for the stage, from the drop-down list.
   Target Value	Specifies the target value for the stage, 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.
   Maximum Threshold	Specifies the maximum threshold.
   Size	Specifies the size.
   Force standard shape and equal stage widths	Indicates whether Oracle BI will automatically force the display.
   Interaction	Indicates the level of interaction allowed in the chart. Choices include None, Drill, and Navigate. NOTE:  When you select Navigate from the Interaction drop down list, the navigation targets defined for the column on which the funnel chart is based on, are applied.

3. When you are done, you can save the request with the funnel chart view.

Related Topics

Overview of Oracle BI Answers

Performing Common Tasks When Working with Oracle BI Views