| Print Open PDF Version of Online Help

#### Showing Results in Funnel Views Use the Funnel view to show results as a three-dimensional graph that represents target and actual values and levels by colour. Typically, Funnel views 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 views 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 coloured areas to drill down to more detailed information. In Funnel views, the thresholds indicate a percentage of the target value, and colours provide visual information for each stage. By default, the Funnel view shows the following: All stages for which the actual value falls below the minimum threshold are coloured in red. All stages for which the actual value falls below the maximum threshold are coloured in yellow. All stages for which the actual value is greater than the maximum threshold are coloured in green. You can change the colours if you wish. The following table describes the types of Funnel views that are available. The style of each can be either solid or gradient fill.
Layout | Description
--- | ---
Standard | A Standard Funnel view uses a standard shape with equal stage widths.
Non-Standard | A Non-Standard Funnel view uses a standard shape with unequal stage widths.
Last-Stage Only | A Last-Stage Only Funnel view uses a standard shape with equal stage widths. It is similar to a Standard Funnel view, except that the target value of every stage before the last stage is calculated based on the last stage target value and a constant called target factor.
The following procedure describes how to edit a Funnel view. To edit a Funnel view If the view is not already in the compound layout, then add the view. For instructions on adding views, see Adding and Editing Views. In the Results tab of the analysis editor, click the Edit View icon for the Funnel view. The Funnel view editor opens. In the Layout pane, drag and drop columns into the drop targets as necessary. In the Settings pane, set the thresholds. The thresholds indicate a percentage of the target value. You can specify custom thresholds in percentages, or use dynamic thresholds. You can also change the colours that are used for each stage. Click the Edit graph properties icon in the toolbar. In the Graph properties dialogue box, make your selections. You can specify the following: Properties related to the graph canvas, such as width, height, and legend location Properties that control the appearance of the graph, such as the style Properties that control the display of titles and labels for the graph When you finish making your changes, click OK to close the Graph Properties dialogue box. When you finish making changes, click Done to close the Funnel view editor. Save the analysis.

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.