Analytics > Designing an Analysis > Step 2: Reviewing Results and Creating Layouts > Showing Results in Funnel Graphs
Showing Results in Funnel Graphs
Use the Funnel Graph view to show results as a three-dimensional graph that represents target and actual values and levels by color. Typically, funnel graphs 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 graphs 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 graphs, 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 Graph view
- In the Results tab, perform one of the following actions:
- Make your selections for the fields in the workspace.
The following table describes the fields.
Funnel Graph View Workspace Field
|
Description
|
Graph Title
|
Specifies the title to display at the top of the graph.
|
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 Oracle CRM On Demand automatically forces a standard shape and equal-stage widths in the graph.
|
Interaction
|
Indicates the level of interaction allowed in the graph. Choices include None, Drill, and Navigate.
|
- Select the Display Results check box to preview the funnel graph view.
- Click OK to return to the Layout Views page.
- To move or edit the funnel graph view (and other views, as required) on the page, do the following:
- To move the view to a different location on the page, drag the view, and drop it in the new location.
- To format the appearance of the funnel graph view, click the Format View button for the view.
You can specify Cell, Border, Background, and Additional Formatting Options (Width, Height, Indent, Right Padding, Top Padding, Bottom Padding).
- To edit the funnel graph view, click the Edit View button for the view.
- To delete the funnel graph view, click the Delete View button for the view.
- When you finish making your changes, save the report.
|