BI Composer wizard -- Create Analysis: Edit Graph panel

This panel is available only if you have added a graph view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel".

Use this panel of the "BI Composer wizard" to:

• Edit the properties and layout of the graph (if you have included a graph view). You can create prompts, use a column to section the analysis, and exclude certain columns from the graph.

• Preview the results.

For more information, see:

• "What Is BI Composer?"

• "Creating Analyses Using BI Composer"

• "Editing Analyses Using BI Composer"

This panel is also displayed as:

Edit Analysis Analysis_Name: Edit Graph panel

Components

Subtype

Use this box to select the graph subtype.

Vary Color By

This target area is not available for pie graphs.

Displays the columns for which each column value or column value combination is to be shown in a different color.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Group By or Points

This target area is named Group By for bar, area, and line-bar graphs, and Points for scatter graphs.

This target area not available for pie graphs.

Displays the columns for which the axis labels are to be clustered into groups. For example in a vertical bar graph whose criteria includes the Region, District, and Dollars column, if this target area contains the Regions column, then the data is grouped by region on the horizontal axis.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Slices

This target area is available only for pie graphs.

Displays the columns for which each column value or column value combination is to be shown as a separate slice of the pie.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Pies

This target area is available only for pie graphs.

Displays the columns for which each column value or column value combination is to be shown as a separate pie.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Move To

Displays the following options to move a column to a different target area:

• Group By — (This option is not available in the Move To menu in the Rows target area.) Moves the column to the Rows target area.

• Vary Color By — (This option is not available in the Move To menu in the Columns target area.) Moves the column to the Columns target area.

• Prompt For — (This option is not available in the Move To menu in the Prompt For target area.) Moves the column to the Prompt For target area.

• Section By — (This option is not available in the Move To menu in the Section By target area.) Moves the column to the Section By target area.

• Excluded — (This option is not available in the Move To menu in the Excluded target area.) Moves the column to the Excluded target area.

Additional Layout Options

Use this option to display the following target areas Prompt For, Section By, and Excluded.

Prompt For

Displays the columns that are to be displayed as prompts. Use this target area to move a column to another other target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Section By

Displays the columns that are to be to used to divide the graph into sections. Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Excluded

Displays the columns that are to be excluded from the view. Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Up and Down Arrows

Use these buttons to reorder the columns in the target areas.

Preview

Use this box to specify whether to display a preview of the results:

• Select this box to display a preview of the actual analysis and data.

  
  

  Note: Selecting this box might impact performance if the query for data results in very large data sets.

  
  

• Deselect this box to display an image that represents each view in the analysis.

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.